Scribd
Upload
3 views1 page

Query Ex 1 Key

The document contains SQL queries related to orchestras and their members. The first query retrieves orchestra names based on concert cities from 2013, the second selects experienced members from well-rated orchestras, and the third finds orchestras with a higher year than 'Chamber Orchestra' and a rating above 7.5. These queries are aimed at filtering data based on specific criteria.

Uploaded by

swathi pugal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views1 page

Query Ex 1 Key

The document contains SQL queries related to orchestras and their members. The first query retrieves orchestra names based on concert cities from 2013, the second selects experienced members from well-rated orchestras, and the third finds orchestras with a higher year than 'Chamber Orchestra' and a rating above 7.5. These queries are aimed at filtering data based on specific criteria.

Uploaded by

swathi pugal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1.

SELECT name
FROM orchestras
WHERE city_origin IN (SELECT city FROM concerts WH
ERE year = 2013);
2.
SELECT
name,
position
FROM members
WHERE experience > 10
AND orchestra_id NOT IN (SELECT id FROM orchestras
WHERE rating < 8.0);
3.
SELECT name
FROM orchestras
WHERE year > (SELECT year FROM orchestras
WHERE name = 'Chamber Orchestra')
AND rating > 7.5;

You might also like