Practice Center – where statement on numbers

Step 1/3: Your goal

Display the cities (column city) for which the revenue (column revenue) of the firm is strictly greater than 10000, smaller than or equal to 30456.23, and different from 20023.34. Revenues are stored in the table called sales. This exercise corresponds to the lesson on SQL where.

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 the name of 3 cities: Achalpur, Adalaj, Agra.

Next exercise: select with like.

Share on:

Last udpated: March 1, 2018
Created: January 10, 2015