Make a SELECT statement that returns the GuestID from the GUEST table 1. Add the tables...

Transcribed Image Text:

Make a SELECT statement that returns the GuestID from the GUEST table 1. Add the tables SERVICE and FEE. JOIN them in your query. 1. Use WHERE and the IN operator to filter the service names room rate, damage, and room service 1. Add the GROUP BY so that aggregate functions are calculated for each GuestID 1. Add the returning column TotalFeeCharged which is the aggregated SUM of the FeeCharged for each GuestID Make a SELECT statement that returns the GuestID from the GUEST table 1. Add the tables SERVICE and FEE. JOIN them in your query. 1. Use WHERE and the IN operator to filter the service names room rate, damage, and room service 1. Add the GROUP BY so that aggregate functions are calculated for each GuestID 1. Add the returning column TotalFeeCharged which is the aggregated SUM of the FeeCharged for each GuestID

Answer rating: 100% (QA)

You can create a SQL query that fulfills your requirements like this sql SEL... View the full answer