Practice Center – Simple Select

Exercise 1

Display the first name (column first_name), last name (column last_name) and phone number (column phone_number) belonging to all clients included in the table clients:

Exercise 2

Display the state (column state) corresponding to the client which ID (column client_id) is equal to 9:

Exercise 3

Display the client IDs (column client_id) of clients who are based in Kerala (column state):

Exercise 4

Display all the information contained in the table called clients

Next lesson: SQL distinct, order by, count.
Next exercise: order by.

Share on:

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