Join Statements - Lab
Introduction
In this lab, you'll practice your knowledge of join statements, using various types of joins and various methods for specifying the links between them.
Objectives
You will be able to:
- Write queries that make use of various types of Joins
- Join tables using foreign keys
CRM Schema
In almost all cases, rather then just working with a single table you will typically need data from multiple tables. Doing this requires the use of **joins ** using shared columns from the two tables.
In this lab, you'll use the same Customer Relationship Management (CRM) database that you saw from the previous lesson.
Connecting to the Database
Import the necessary packages and connect to the database data.sqlite.
#Your code here
Display the names of all the employees in Boston.
Hint: join the employees and offices tables.
#Your code here
Do any offices have no employees?
Hint: Combine the employees and offices tables and use a group by.
#Your code here
Write 3 Questions of your own and answer them
# Answers will vary
# Your code here
# Your code here
# Your code here
Level Up: Display the names of each product each employee has sold
# Your code here
Level Up: Display the Number of Products each employee has sold
# Your code here
Summary
Congrats! You now know how to use join statements, along with leveraging your foreign keys knowledge!