A Guide to SQL, Ninth Edition Solutions 5–13
SELECT RESERVATION_ID, TRIP_ID, TRIP_DATE
FROM RESERVATION
8.
SELECT LAST_NAME, FIRST_NAME
9.
SELECT LAST_NAME, FIRST_NAME
10.
SELECT F.TRIP_ID, F.TRIP_NAME, S.TRIP_ID, S.TRIP_NAME, F.START_LOCATION
11.
SELECT TRIP_NAME
12.
SELECT CUSTOMER_NUM, LAST_NAME
FROM CUSTOMER
13.
SELECT CUSTOMER_NUM, LAST_NAME
14.
SELECT TRIP_ID, TRIP_NAME
15.
SELECT TRIP_ID, TRIP_NAME
16.
SELECT TRIP.TRIP_ID, TRIP_NAME, RESERVATION_ID
A Guide to SQL, Ninth Edition Solutions 5–19
17. [Critical Thinking]
SELECT DISTINCT(LAST_NAME), FIRST_NAME
18. [Critical Thinking]
SELECT DISTINCT(TRIP_NAME)
Answers to Solmaris Condominium Group Exercises
1.
SELECT LOCATION_NUM, UNIT_NUM, CONDO_FEE, CONDO_UNIT.OWNER_NUM,
2.
SELECT CONDO_ID, DESCRIPTION, STATUS
3.
SELECT SERVICE_REQUEST.CONDO_ID, LOCATION_NUM, UNIT_NUM, EST_HOURS,
4.
SELECT FIRST_NAME, LAST_NAME
5.
SELECT FIRST_NAME, LAST_NAME
6.
SELECT F.UNIT_NUM, S.UNIT_NUM
7.
SELECT SQR_FT, CONDO_UNIT.OWNER_NUM, LAST_NAME, FIRST_NAME
8.
SELECT SQR_FT, CONDO_UNIT.OWNER_NUM, LAST_NAME, FIRST_NAME
9.
SELECT LOCATION_NUM, UNIT_NUM, CONDO_FEE
FROM CONDO_UNIT, OWNER
10.
SELECT LOCATION_NUM, UNIT_NUM, CONDO_FEE
FROM CONDO_UNIT, OWNER
11.
SELECT LOCATION_NUM, UNIT_NUM, CONDO_FEE
FROM CONDO_UNIT, OWNER
12.
SELECT SERVICE_ID, CONDO_ID
13.
SELECT SERVICE_ID, CONDO_ID
14.
SELECT CONDO_UNIT.CONDO_ID, SQR_FT, OWNER_NUM, SERVICE_ID,
15.
SELECT CONDO_UNIT.CONDO_ID, SQR_FT, OWNER_NUM, SERVICE_ID,
16. [Critical Thinking]
SELECT CONDO_UNIT.CONDO_ID, SQR_FT, OWNER_NUM, SERVICE_ID,
Exercise 15 uses a left outer join and and Exercise 16 uses a right outer join. Both