learn-co-students / dsc-0-05-10-join-statements-lab-nyc-ds-091018

Join Statements

Introduction

In this lab, you'll practice your knowledge on Join statements.

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 we will typically need data from multiple tables. Doing this requires the use of **joins ** using shared columns from the two tables.

In this lab, we'll use the same Customer Relationship Management (CRM) database we used in our lecture before!

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.

#Your code here

Do any offices have no employees?

#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!