Task 11 (10 marks) We allow some customers to pay in instalments. Create a view that...

 

Transcribed Image Text:

Task 11 (10 marks) We allow some customers to pay in instalments. Create a view that shows the total amount of money that has been paid towards each job. Only show the jobs that have been completed. But make sure to include completed jobs even if they have had no payments. This can be achieved by selecting from the JobCompleted table, and left joining to the Payment table. The result should have (Jobld, Amount Paid, LatestTimestamp, NumberOfPayments) Latest Timestamp should show the timestamp of the last payment made. If there are any jobs that have not received any payments, use IFNULL() to ensure that the Amount Paid shows zero and that LatestTimestamp instead shows the time of job completion. Task 11 (10 marks) We allow some customers to pay in instalments. Create a view that shows the total amount of money that has been paid towards each job. Only show the jobs that have been completed. But make sure to include completed jobs even if they have had no payments. This can be achieved by selecting from the JobCompleted table, and left joining to the Payment table. The result should have (Jobld, Amount Paid, LatestTimestamp, NumberOfPayments) Latest Timestamp should show the timestamp of the last payment made. If there are any jobs that have not received any payments, use IFNULL() to ensure that the Amount Paid shows zero and that LatestTimestamp instead shows the time of job completion.

Answer rating: 100% (QA)

Solution This SQL query would show the required view CREATE VIEW J... View the full answer