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