Need help to answer following questions ?
- Total invoice amount
- Total receipt amount
- Total invoice amount not paid
- Total amount paid without invoices
Please write an SQL script to show total amount paid by the employer for the following scenario:
Students enrolled in courses (see the course offering, and course connection objects – the course connection object acts as the enrollment table of a contact to a course) and received invoices. The students submitted the invoices to their employers. The employers paid the invoices and receipts were issued to them. Records of both student and employer as contacts.