Question: * Problems 1 3 - 1 5 do not start with SELECT P 1 3 . Write an SQL statement that will set the value

*Problems 13-15 do not start with SELECT
P13. Write an SQL statement that will set the value of the City columns to 'Northridge', but only the ones where the Country column has the value "USA" (10 points).
P14. Write an SQL statement that will delete all the records from the Customers table where the State value is 'California' (10 points).
P15. Write an SQL statement that will insert a new record in the Customers table (10 points).*Use INSERT INTO () and VALUES ()
Here is the new record:
CustomerName: YOUR FRIST and LAST NAME
Address: 18111 Nordhoff St.
City: Northridge
PostalCode: 91330
Country: USA
* Problems 1 3 - 1 5 do not start with SELECT P 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!