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 (revenues are recorded in the table sales), but showing only states for which the total revenue is greater than 60000. 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 2 rows. This table should show the following results:
Next exercise: group by part III.