Hello, I am trying to get this to work right, but it keeps saying that my FROM isn't stated correctly.
What do I have wrong?
SELECT RESERVATION_ID, TRIP_ID, CUSTOMER_NUM, ('TRIP_PRICE' + 'OTHER FEES') * NUM_PERSON AS 'TOTAL_PRICE'
FROM RESERVATION, TRIP, CUSTOMER
WHERE NUM_PERSONS > 4
AND 'RESERVATION_ID' = 'TRIP_ID'
AND CUSTOMER 'CUSTOMER_NUM' = RESERVATION 'CUSTOM_NUM';