Practice Center – select case

Exercise:

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:

Something not clear? Ask your question here:

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

 
 

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