Answer Happy

Posted: **Fri May 20, 2022 12:30 pm**

: Question 2 25 Points Consider The Following Schema For Managing Performance Information Of Artists In Theaters Artis 1 (21.66 KiB) Viewed 47 times

: Question 2 25 Points Consider The Following Schema For Managing Performance Information Of Artists In Theaters Artis 2 (8.83 KiB) Viewed 47 times

: Question 2 25 Points Consider The Following Schema For Managing Performance Information Of Artists In Theaters Artis 3 (4.46 KiB) Viewed 47 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.