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.