Question

please help me in this problem​

Answer 1

Answer:

Write the SQL statements to find each of the followings: 1. Clients who do not have any payments. 2. Invoices with no payments. 3. Create a view that contains: InvNo, date, amt, payNo, date, amount, for invoices with and without payments, and payments with or without invoices. 1. Write the function "ClientBalance", which returns the difference between total invoice amount and total payment amount for a given client. 2. List of clients with their Balance, in case their balance is over 10000. 3. Write the previous function as a procedure. 4. Write the necessary triggers that update balance when a new invoice or payment is made by a client.