MySql Database

1. Write the SQL query for the following questions, base on the database structure provided below.

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. (notice name is not under 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.

Individuals Columns taxpayerlD name address spouselD lastDateFiled lastDatePaid totalTaxOwed IRSagents Columns IRSagentlD taxpayerlD jobLevel active | TaxReturns 5 Columns taxpayer!D taxYear kind dateFiled income taxOwed Payments Columns taxpayerlD datePaid amountPaid Delinquents Columns taxpayerlD IRSagentlD collectionAgenc... Businesses Columns taxpayerlD name address businessType lastDateFiled lastDatePaid totalTaxOwed