Practice Center – Select with Where

Exercise 1

Show the transaction date (column transaction_date) and state (column state) of sales transactions (table “sales”) that took place in the year (column “year”) 2013.
Enter the corresponding query in the edit box below and click on the “Send” button underneath:


Exercise 2

show the first name (column first_name) ,last name (column last_name) and state of clients (table clients) which last name ends with the letter “o”.


Exercise 3

Show the client id (column client_id) and first name of clients which first name contains the string “mi”


Exercise 4

show the first name (column first_name) and the last name (column last_name) of clients (table clients) which last name start with the letter “m”.


Exercise 5

show the transaction id (column transaction_id) of sales transactions which amount (column “revenue”) is greater than or equal to 30456.23


Exercise 6

show the state and revenue for all transactions that did NOT took place in achalpur


Exercise 7

select all columns from table sales, but showing only rows for which the value of the column revenue is between 30000 and 50000.


Exercise 8

show the transaction id (column transaction_id) and the city of sales transactions which amount (column “revenue”) is strictly greater than 30456.23


Exercise 9

show the transaction id (column transaction_id) and the city of sales transactions which amount (column “revenue”) is strictly smaller than 30456.23


Exercise 10

show the transaction id (column transaction_id) of sales transactions which amount (column “revenue”) is smaller than or equal to 30456.23


Next exercise: where statement on numbers.

 
Share on:


Author:
Last udpated: September 10, 2017
Created: December 20, 2014