Practice Center – Group By part III

Step 1/3: Your goal

Display a list of states ( column state, table sales), showing for each state the total revenue (column revenue) recorded in this state for the year 2014 (column year). This exercise corresponds to the lesson on group by.

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 a table with 2 columns and 3 rows. This table should show the following results:
gujarat: 10222.99
maharastra: 10000.12
uttar pradesh: 20023.34

Share on:

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