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:

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>


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