Hi. Can you help me, please with some queries in sql? Thank you 1.Using a subque

Question

Hi. Can you help me, please with some queries in sql? Thank you

1.Using a subquery, which trips have no reservations?

2.Using a subquery, which guests have spent more than $50 for all their reservations?

TRIP RESERVATION TRIP ID TRIP NAME START LOCATION STATE DISTANCE MAX GRP SIZE TYPE SEASON RESERVATION ID TRIP ID TRIP DATE NUM PERSONS TRIP PRICE OTHER FEES GUEST NUM TRIP GUIDES TRIP ID GUIDE NUM GUEST GUIDE GUIDENUM LAST NAME FIRST NAME ADDRESS CITY STATE POSTAL CODE PHONE NUM HIRE_DATE GUEST NUM LAST NAME FIRST NAME ADDRESS CITY STATE POSTAL CODE PHONE NUM

Explanation / Answer

If you have any doubts, please give me comment...

-- 1)

SELECT TRIP_ID, TRIP_NAME

FROM TRIP

WHERE TRIP_ID NOT IN(

SELECT TRIP_ID

FROM RESERVATIONS

);

-- 2)

SELECT GUEST_NUM, LAST_NAME, FIRST_NAME

FROM GUEST G

WHERE 50 < ANY(

SELECT TRIP_PRICE+OTHER_FEES

FROM RESERVATION R

WHERE G.GUEST_NUM = R.GUEST_NUM

);

-- 3)

SELECT GUIDE_NUM, LAST_NAME, FIRST_NAME

FROM GUIDE

WHERE GUIDE_NUM IN(

SELECT GUIDE_NUM

FROM TRIP_GUIDES

);

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.