Practice Center – SQL Update

Exercise 1

Change phone number (column phone_number) to 2111111111 of client (table clients) which first name (column first_name) is equal to “anuragh” and last name is equal to “gupta” (column last_name).


Exercise 2

Change email address (column email_address) to “[email protected]” of client (table clients) which ID (column client_id) is equal to 8.


Exercise 3

Change state (column state) to “Karnataka” and salesperson ID (column salesperson_id) to 1 of client (table clients) which ID (column client_id) is equal to 7.


Exercise 4

Divide the value in column revenue in table sales for rows corresponding to the state “maharastra”.


 
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: March 6, 2016
Created: March 6, 2016