/* Part 5: */
SELECT CID, FNAME, SNAME, CADDRESS, CPHONE
from Customer
Order by CID

SELECT B.TOURCODE, B.TOURDATE, E.EXPERT_NAME
FROM BOOKING B
INNER JOIN EXPERT E
ON B.TOURCODE = E.EXPERT_NAME

SELECT TOURCODE, TOURDATE, CID, FNAME, SNAME
FROM BOOKING
ORDER BY TOURCODE, TOURDATE, CID

SELECT A.TOURCODE, A.TOURDATE, A.GIFT_ID, G.GIFT_NAME
FROM GIFT_ALLOCATION A
INNER JOIN GIFT G
ON  A.CID = G.GIFT_ID
ORDER BY A.TOURCODE, A.TOURDATE, GIFT_ID


SELECT A.TOURCODE, A.TOURDATE, A.CID, C.FNAME, C.SNAME, A.GIFT_ID, G.GIFT_NAME
FROM GIFT_ALLOCATION A
INNER JOIN CUSTOMER C
ON A.CID = C.CID
INNER JOIN GIFT G
ON A.CID = G.GIFT_ID
ORDER BY A.TOURCODE, A.TOURDATE, A.CID, A.GIFT_ID