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 specifView the full answer