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

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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!