Practice Center – select case


Display the cities (column city) as well as the revenue level (must show up as column level in the result set) of the firm in these cities. Revenues are stored in the table called sales. Revenue level: display “very high” if the revenue is 40000 or above; display “high” if the revenue (column revenue) is 25000 or above; display “medium” if the revenue is strictly smaller than 25000. This exercise corresponds to the blog post on formatting your query results.

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

Next exercise: select with where.

Share on:

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