7. The database should be able to produce and provide a sample report with dummy data....

Transcribed Image Text:

7. The database should be able to produce and provide a sample report with dummy data. (Hint: Fields from multiple tables should be used to develop the sample reports.) Create the SQL queries and provide the screenshots for the following: . . . . List the balance due to MovinOn from each customer inclusive of moving jobs and rentals for a specific month. List the amount due to each driver for moving jobs conducted in a specific month. Be sure to consider fees that drivers are charged based on performance ratings. List the drivers and their corresponding job details. List the revenues for MovinOn in a particular month once drivers and employees have been paid out. Revenues should include both moving jobs and rentals. List the storage units that have not been leased and are available. 7. The database should be able to produce and provide a sample report with dummy data. (Hint: Fields from multiple tables should be used to develop the sample reports.) Create the SQL queries and provide the screenshots for the following: . . . . List the balance due to MovinOn from each customer inclusive of moving jobs and rentals for a specific month. List the amount due to each driver for moving jobs conducted in a specific month. Be sure to consider fees that drivers are charged based on performance ratings. List the drivers and their corresponding job details. List the revenues for MovinOn in a particular month once drivers and employees have been paid out. Revenues should include both moving jobs and rentals. List the storage units that have not been leased and are available.

Answer rating: 100% (QA)

List the balance due to MovinOn from each customer inclusive of moving jobs and rentals for a specif... View the full answer