Question

India has a long tradition of government planning, but the degree of government intervention in the economy has been reduced in the last two decades. Privatisation started in 1991, with the creation and sale of a small number of shares in some SOES. This process speeded up in the first decade of the 2000s. It slowed down in the second decade, but there was still some debate about whether a number of state-run enterprises, including the national airline, Air India, should be transferred from the private to the public sector. Explain one reason for better performance of a firm when: a it is in the private sector bit is in the public sector.​

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.