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 “test@lula.net” 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:


Author:
Last udpated: March 6, 2016
Created: March 6, 2016