Question

2. Observe the figure given below carefully and answer the questions:- ​

Answer 1

Answer:. Observe the figure given below carefully and answer the questions:- ​

Explanation:

in this you have to observe the figure ok                                                                                                          is my ans is correct then mark me as brainlist answer

Answer 2

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.