DB Quacks SQL Tutorial · Chapter 6
The Matrix: PIVOT Reloaded
Agent Smith Duck appears in dark sunglasses. Welcome to the Matrix! Reality is about to change. Transform boring row data into a cross-tabulation matrix - species as rows, pond names as columns. Bend the data!
Your task
Create a cross-tabulation showing species as rows and pond names as columns with visit counts by joining the ducks table with 'data/pond_visits.csv'. You will be transforming row data into a matrix format.