This task demonstrates basic SQL operations including SELECT, WHERE, ORDER BY, GROUP BY, HAVING, BETWEEN, and LIKE using the Chinook database.

Columnstore indexes give great performance to queries that scan large sets of rows (millions of rows typically), and also provides huge savings in storage space. Typical compression rates can be 90%.