(solution) Q.1.. Write sql statements to do the following: Write an insert

(solution) Q.1.. Write sql statements to do the following: Write an insert

Q.1.. 

Write sql statements to do the following:

Write an insert statement that inserts a new record into the Customers table. Insert following: ID 1000000006, Bruin Store, 100 Bruin Way, Lue Strings PA 93025 USA,Joe [email protected]

Q.2.. 

Write sql statements to do the following:

Write an insert statement that inserts partial row into the Customers table. Insert following columns: ID 1000000007, Bruin Store, 100 Bruin Way, Lue Strings PA 93025 and USA

Q.3.. 

Write sql statements to do the following:

Write an update statement that updates cust_state in the Customers table to ?PA? where cust_id = 1000000006

Q.4… 

Write a sql statements to do the following:

Write a delete statement that deletes record 1000000007 from the customer table. If that Cust_ID does not exist check table and use an existing cust_id. If the record 1000000007 does not exist use any existing customer record.

Q.5.. 

Write a sql statements to do the following:

 Write a statement that updates two fields for record 1000000006. Those fields are the address and City in the Customers table . If the record 1000000006 does not exist use any existing customer record. Change address to 1 Bruin Walk and City to Greentowns