Question 2 25 Points Consider The Following Schema For Managing Performance Information Of Artists In Theaters Artis 1 (21.66 KiB) Viewed 45 times
Question 2 25 Points Consider The Following Schema For Managing Performance Information Of Artists In Theaters Artis 2 (8.83 KiB) Viewed 45 times
Question 2 25 Points Consider The Following Schema For Managing Performance Information Of Artists In Theaters Artis 3 (4.46 KiB) Viewed 45 times
Question 2 (25 points): Consider the following schema for managing performance information of artists in theaters. Artist (ssn, name, age, rating) Theater (tno, tname, address) Perform (ssn, tno, date, duration, price) Write the following queries in SQL (1) Retrieve the name and rating of each artist who has performed or will perform in the "Sacramento Memorial Auditorium". (2) Retrieve the name of each artist who performs in the "Sacramento Memorial Auditorium” today. Assume the date has the format of MM/DD/YYYY.
(3) Find the average age of artists who performed at least 3 times in the "Sacramento Memorial Auditorium". (4) Find the name of each artist whose rating is more than the average of all the artists.
(5) Find the name of each theater that has at least 5 performances in the following 10 days from today.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!