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:


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