Answered step by step
Verified Expert Solution
Question
1 Approved Answer
*Postgresql question: this is a question from Postgresql where i need to write a query to obtain the yearly summary report of each month's sales
*Postgresql question: this is a question from Postgresql where i need to write a query to obtain the yearly summary report of each month's sales as columns. I have one table "sale1" that has records for months in 2019 and 2018 showing year, month, and s (for sales). Table being extracted from is the first picture. (from terminal) 2nd picture is what the output should look like. Obtain yearly summary report listing each month's sales as columns. Table 51: Displaying records 1 - 10 year months 2019 2019 2019 2019 2019 2019 2019 VOCTA CON year months 2019 8 38 2019 999 2019 10 58 Table 52: 2 records year jan feb mar apr may jun jul aug 2019 976 99 994990 22 38 2018 62 52 58 547 89 69 13 sep 99 50 oct nov dec 58 74 36 97 1993 Terminal Help File Edit View Search puwey year | month | s ----+---- 2019 1 | 97 2019 26 2019 3 99 2019 4 99 2019 549 2019 6 | 90 2019 7 | 22 2019 8 38 2019 999 2019 10 58 2019 11 74 2019 12 | 36 2018 1 | 62 2018 252 2018 3 | 58 2018 54 2018 5 | 7 2018 6 | 89 2018 7 | 69 2018 8 | 13 2018 9 | 50 2 A18 197 Table 52:2 records year jan feb mar apr may jun jul aug 2019 976 99 99 49 90 22 38 2018 62 52 58 54 7 89 169 13 sep 99 50 oct nov dec 58 74 36 57 19 93
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started