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:

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>

 
 

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