MySql Database

1. Write the SQL query to answer the question

Questions to Answer The tables of the schema record IRS information. Tax returns are submitted by tax payers who may be individuals (kind is I) or businesses (kind is B). Tax payers may make payments. Different information is kept about individuals and businesses. A business may have businessType C (corporation), P (partnership) or L' (limited liability company). IRS agents are employees of the IRS. Delinquents are tax payers who have owed money for a long time.

1) List down average totaltaxOwed by each business type. Display business type and average total tax owed.

2) Show the names of all those individuals and their corresponding tax id, last date tax filed and total tax owed such that these individuals have filed their taxes after 2015-03-01 and owe total tax more than 5000 USD.

3) Show the names of the individual and their corresponding IRSAgentsID and order them in decreasing order of the job level of IRSAgents.

4) Find the names of the individuals and businesses who have made not more than three payments.

5) List down Individuals names and their addresses who do not have a spouse and owe tax less than 5000 USD.