Consider our ski resort data example:

PassHolder (passID, name, age, streetAddress, city, state)

Resort (resortName, city, state, baseElevation, verticalFeet)

Lift (liftNumber, baseElevation, topElevation, numSeats, speed)

ValidAt (passID, resortName )

PartOf (resortName, liftNumber

Rode (passID, liftNumber, date, time)

Write SQL queries for:

1. Find the passID of pass holders whose pass is valid at each and every resort.
2. Find the name of pass holders who have ridden every lift.
3. Find the name of pass holders who have ridden every lift operated by Vail Resorts.
4. Find the name and city of resorts that have at least one lift whose base elevation is below 9,000 feet.
5. Find the name and state of pass holders that hold a valid pass for a resort that is located in the same state they live in.
6. Find the resorts that have at least one lift whose top elevation is above 12,000 feet.
7. Find the liftNumber of all lifts that have been ridden by pass holders that live in the city of Denver.