Filters

Access

FreePremium

Difficulty

Skill Focus

Basic Data RetrievalData FilteringSort OperationsRow FunctionsGroup FunctionsJoin StatementsSubqueriesSet OperatorsConditional LogicCTEsWindow FunctionsRanking FunctionsPositional FunctionsAggregate Window FunctionsRecursive CTEsPivot & UnpivotAverage Deal SizeCustomer Acquisition CostExpansion & UpsellExpansion MRRPayback PeriodSaaSSales Cycle LengthSales Pipeline & ConversionUnit EconomicsWin Rate

Select topics to filter

Sort:

1 / 24

	Skill Focus	Tags
List All Music Artist Names	List the names of all artists in the database.	Easy Basic Data Retrieval
Retrieve All Album Titles	Display the titles of all music albums.	Easy Basic Data Retrieval
Find Customer Contact Emails	Get the first names and email addresses of all customers.	Easy Basic Data Retrieval
Show Track Names and Composers	List track names along with their respective composers.	Easy Basic Data Retrieval
Display Invoice Dates and Totals	Show the date and total cost for every invoice.	Easy Basic Data Retrieval
List All Available Music Genres	Retrieve the names of all music genres.	Easy Basic Data Retrieval
Show Employee Job Titles	List employee names and their professional titles.	Easy Basic Data Retrieval
List Music Media Types	Show the different file formats available for music.	Easy Basic Data Retrieval
Display All Playlist Names	Retrieve a list of all playlist names.	Easy Basic Data Retrieval
Find Unique Track Composers	List every unique composer represented in our catalog.	Easy Basic Data Retrieval
Identify Unique Employee Cities	Show the different cities where our staff is based.	Easy Basic Data Retrieval
List All Unique Billing Countries	Determine every unique country listed on our store invoices.	Easy Basic Data Retrieval
Discover Unique Customer States	See every unique state represented in the customer list.	Easy Basic Data Retrieval
Identify Customers Located in Brazil	Filter the customer list to show only those living in Brazil.	Easy Data Filtering
Find High Value Invoices	List all invoices with a total cost above fifteen dollars.	Easy Data Filtering
Short Music Tracks	Find tracks shorter than one minute and sort them.	Easy Data Filtering
European City Customers	Filter customers living in specific European capitals.	Easy Data Filtering
Invoices from Early 2021	Retrieve sales records within a specific three month period.	Easy Data Filtering
Find Tracks Starting with The	Search for song titles beginning with the word The.	Easy Data Filtering
Identify Support Staff in Calgary	Locate employees with a specific job title in one city.	Easy Data Filtering +1 more

SQL Practice Exercises Online

Filters