Hello, I need help with a database question table 1 deciration_id type total_income table 2 Presentation ID, tax code, year, declaration ID table 3 tax code, surname, name, address, city, region Create the queries needed to perform the following tasks. 1) Calculation of the average total income declared for taxpayers in the "Lombardy* region 2) Counting of the declarations made by "Unique" type relating to the year 2003. 3) List, by year of presentation, of the maximum and minimum value of total income declared.
Hello, I need help with a
table 1
deciration_id
type
total_income
table 2
Presentation ID, tax code, year, declaration ID
table 3
tax code, surname, name, address, city, region
Create the queries needed to perform the following tasks. 1) Calculation of the average total income declared for taxpayers in the "Lombardy* region
2) Counting of the declarations made by "Unique" type relating to the year 2003.
3) List, by year of presentation, of the maximum and minimum value of total income declared.
4) Calculation of the year that recorded the lowest total declared income.
5) List of all taxpayers with the related average income declared, even for taxpayers who
had not made any statements.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
