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:
uttar pradesh: 20023.34