Practice Center – select count part II

Step 1/3: Your goal

Display the number of rows in the table sales for which year is equal to 2014.

This exercise corresponds to the lesson on select distinct, order by and count.

Step 2/3: Get started

Enter the corresponding query in the edit box below and click on the “Submit Query” button underneath:



Step 3/3: Verify your results

After clicking on “Submit Query”, you should see below the following result for the count: 4

Next lesson: select with where.
Next exercise: select case.

 
Share on:


Author:
Last udpated: September 10, 2017
Created: January 1, 2015