Task 3: Join in on the Fun
Time to start joining! You can choose the type of join you use, just make sure to make a note in your notebook as to why you chose that join! You can answer these questions after Chapter 9: SQL Part 3
Question
Join annual_2016
with series on series_id
. We only want the data in the annual_2016
table to be included in the result.
Question
Join series and datatype on data_type_code
.
Question
Join series and industry on industry_code
.