Artist (ssn, name, age, rating) Theater (tno, tname, address) Perform (ssn, tno, date, duration, price) Question 3 (5
Posted: Fri May 20, 2022 12:30 pm
- Artist Ssn Name Age Rating Theater Tno Tname Address Perform Ssn Tno Date Duration Price Question 3 5 1 (3.99 KiB) Viewed 40 times
- Artist Ssn Name Age Rating Theater Tno Tname Address Perform Ssn Tno Date Duration Price Question 3 5 2 (11.48 KiB) Viewed 40 times
Question 3 (5 points): Consider the schema in Question 2. Assume the date has the format of MM/DD/YYYY. (1) Write an update SQL statement to increase the prices of all the performances today by 10% (2) Write a delete SQL statement to delete all the performances today.