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.