Question: Make a SELECT statement that returns the GuestID from the GUEST table 1. Add the tables SERVICE and FEE. JOIN them in your query.
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
Step by Step Solution
3.48 Rating (158 Votes )
There are 3 Steps involved in it
You can create a SQL query that fulfills your requirements like this sql SEL... View full answer
Get step-by-step solutions from verified subject matter experts
