can you solve the following queries. SELECT S1.* FROM Singer S1…

Question can you solve the following queries. SELECT S1.* FROM Singer S1… can you solve the following queries.  SELECT S1.* FROM Singer S1 INNER JOIN Singer S2 ON S1.InstructorSingerID = S2.SingerID INNER JOIN BAND B ON B.ManagerSingerID = S2.SingerID INNER JOIN TourEntry TE ON S1.SingerID = TE.SingerID INNER JOIN Tour T ON TE.TourID = T.TourIDWHERE BandName = ‘Moon’ AND TourType = ‘Public’ AND TourYear = 2009Question 21 options:List details of singers that have participated in a “Public” tour in 2009 or their instructors are managers in band “Moon”. List details of singers that have participated in a “Public” tour in 2009 or are managers in band “Moon”.List details of singers that have participated in a “Public” tour in 2009 and are managers in band “Moon”.List details of singers that have participated in a “Public” tour in 2009 and their instructors are managers in band “Moon”.List details of singers that have participated in a “Private” tour in 2009 or their instructors are managers in band “Moon”.   What does the following SQL statement do?SELECT * FROM Singer WHERE InstructorSingerID IN (SELECT SingerID FROM Singer WHERE SingerID IN (SELECT ManagerSingerID FROM Band WHERE BandName = ‘Moon’)) ORSingerID IN   (SELECT SingerID FROM TourEntry WHERE TourID IN (SELECT TourID FROM Tour WHERE TourType = ‘Public’)     AND TourYear = 2009)Question 11 options:List details of singers that have participated in a “Public” tour in 2009 or are managers in band “Moon”.List details of singers that have participated in a “Public” tour in 2009 and are managers in band “Moon”. List details of singers that have participated in a “Private” tour in 2009 or their instructors are managers in band “Moon”. List details of singers that have participated in a “Public” tour in 2009 or their instructors are managers in band “Moon”.List details of singers that have participated in a “Public” tour in 2009 and their instructors are managers in band “Moon”.     What does the following SQL statement do?SELECT * FROM Singer where (City LIKE ‘%Toronto%’ OR City LIKE ‘%Waterloo%’) AND Income > 50000Question 12 options:List all details for singers that their city contains “Toronto” or “Waterloo”, and whose income is less than 50000List all details for singers that their city contains “Toronto” or “Waterloo”, or whose income is over 50000List all details for singers that their city contains “Toronto” or “Waterloo”, and whose income is over 50000List all details for singers that their city contains “Toronto” and “Waterloo”, and whose income is over 50000List all details for singers that their city contains “Toronto” and “Waterloo”, and whose income is less than 50000   Select the SQL statement to satisfy the following query:List details for singers that are instructors of at least 2 other singers.Question 17 options:SELECT * FROM Singer WHERE SingerID IN ( SELECT InstructorSingerID FROM Singer Group By InstructorSingerID WHERE COUNT(*) > 0)SELECT * FROM Singer WHERE SingerID IN ( SELECT InstructorID FROM Singer Group By InstructorID HAVING COUNT(*) > 1)SELECT * FROM Singer WHERE SingerID IN ( SELECT InstructorSingerID FROM Singer Group By InstructorSingerID HAVING COUNT(*) > 1)SELECT * FROM Singer WHERE SingerID IN ( SELECT InstructorSingerID FROM Singer Group By InstructorSingerID HAVING COUNT(*) > 0 )SELECT * FROM Singer WHERE SingerID IN ( SELECT InstructorID FROM Singer Group By InstructorID HAVING COUNT(*) > 0 )  Select the SQL statement to satisfy the following query:List tour details that any singer of band “Orange” entered in 2001. Sequence by tour name.Question 19 options:SELECT * FROM Tour WHERE TourID IN (SELECT TourID FROM TourEntry WHERE TourYear = 2001 AND SingerID IN (SELECT SingerID FROM Singer WHERE SingerID IN (SELECT SingerID FROM Band WHERE  BandName = ‘Orange’) ) ) ORDER BY TourName SELECT * FROM Tour WHERE TourID IN (SELECT Tour FROM TourEntry WHERE TourYear = 2001 AND SingerID IN (SELECT SingerID FROM Singer WHERE SingerID IN (SELECT SingerID FROM Band WHERE  BandName = ‘Orange’) ) ) ORDER BY TourName SELECT * FROM Tour WHERE TourID IN (SELECT TourID FROM TourEntry WHERE TourYear = 2001 AND SingerID IN (SELECT SingerID FROM Singer WHERE SingerID IN (SELECT SingerID FROM Band WHERE  Band= ‘Orange’) ) ) ORDER BY TourNameSELECT * FROM Tour WHERE TourID IN (SELECT TourID FROM TourEntry WHERE TourYear IN 2001 AND SingerID IN (SELECT SingerID FROM Singer WHERE SingerID IN (SELECT SingerID FROM Band WHERE  BandName = ‘Orange’) ) ) ORDER BY TourName SELECT * FROM Tour WHERE TourID IN (SELECT TourID FROM TourEntry WHERE TourYear = 2001 AND SingerID IN (SELECT SingerID FROM Singer WHERE SingerID IN (SELECT * FROM Band WHERE  BandName = ‘Orange’) ) ) ORDER BY TourName  Engineering & Technology Industrial Engineering Operations Management ITM 500 Share QuestionEmailCopy link Comments (0)