SQL queries
Budget: $10 – $30 USD
DEADLINE : 11/18/2022 EST
MAX BUDGET : $20 ( FOR EACH QUESTION - $5)
NOTE CHECK PDF (QUESTIONS) THERE ARE TOTAL 4 QUESTION NEED TO SOLVE
NOTE: CHECK BELOW THERE ARE DIFFERENT 4 REPORTS, AND EACH REPOSTS BELONGS TO EACH QUERY QUESTIONS THOSE ARE NOT OUTPUTS BUT YOU NEED TO CHECK THE COLUMN NAMES THEY MUST SAME THOSE REPORTS ARE JUST FOR BASIC OUTPUT FOR WHICH COLUMN ARE NEEDED. (CHECK ATTACHED PDF: "REPORTS')
NOTE: TWO TYPES OF QUERIES SOLUTION WE NEEDED FOR EACH QUESTION
1) USING "WITH AS " subquery
2) USING nested subquery
NOTE: Character string data (e.g., customer name and product name) are left justified.
2. Numeric data (e.g., Maximum/minimum Sales Quantities) are right justified.
3. Only standard SQL statements and aggregate function syntaxes are used
NOTE : I ALSO UPLOAD THE DATABASE FILE YOU MUST USE THAT
MAX BUDGET : $20 ( FOR EACH QUESTION - $5)
NOTE CHECK PDF (QUESTIONS) THERE ARE TOTAL 4 QUESTION NEED TO SOLVE
NOTE: CHECK BELOW THERE ARE DIFFERENT 4 REPORTS, AND EACH REPOSTS BELONGS TO EACH QUERY QUESTIONS THOSE ARE NOT OUTPUTS BUT YOU NEED TO CHECK THE COLUMN NAMES THEY MUST SAME THOSE REPORTS ARE JUST FOR BASIC OUTPUT FOR WHICH COLUMN ARE NEEDED. (CHECK ATTACHED PDF: "REPORTS')
NOTE: TWO TYPES OF QUERIES SOLUTION WE NEEDED FOR EACH QUESTION
1) USING "WITH AS " subquery
2) USING nested subquery
NOTE: Character string data (e.g., customer name and product name) are left justified.
2. Numeric data (e.g., Maximum/minimum Sales Quantities) are right justified.
3. Only standard SQL statements and aggregate function syntaxes are used
NOTE : I ALSO UPLOAD THE DATABASE FILE YOU MUST USE THAT