Learning Unpivot Function
Top Vendors solution
Source:
https://advancedsqlpuzzles.files.wordpress.com/2018/12/advanced-sql-puzzles.pdf
First and Last Solution
Source:
https://advancedsqlpuzzles.files.wordpress.com/2018/12/advanced-sql-puzzles.pdf
Mission to Mars solution
Source:
https://advancedsqlpuzzles.files.wordpress.com/2018/12/advanced-sql-puzzles.pdf
BQ Public Data cfpb_complaints
But why would you do this convoluted solution?
Which companies are most involved?