SQL Server JOINs - Quiz Part 2 

You know the various joins - but can you join two or three tables together, and retrieve the rows that you need?
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/que...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/dat...
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql...
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql...
SQL Server Integration Services (SSIS): rebrand.ly/sql...
SQL Server Analysis Services (SSAS): rebrand.ly/sql...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/mic...
----
In this video, I'll ask you questions relating to how you create JOINs, and how you can use the WHERE clause to find missing data.
Here is the starting code:
DROP TABLE IF EXISTS tblShops
DROP TABLE IF EXISTS tblPurchases
DROP TABLE IF EXISTS tblCustomers
CREATE TABLE tblShops
(ShopID int PRIMARY KEY,
City varchar(20))
CREATE TABLE tblPurchases
(ShopID int,
CustomerID varchar(6),
PurchaseAmount money
PRIMARY KEY(CustomerID, ShopID))
CREATE TABLE tblCustomers
(CustomerID varchar(6) PRIMARY KEY,
FirstName varchar(20),
Surname varchar(20))
INSERT INTO tblShops VALUES
(1, 'New York'),
(2, 'Boston')
INSERT INTO tblCustomers VALUES
('C-0001', 'John', 'Smith'),
('C-0002', 'Jane', 'Doe'),
('C-0003', 'Hamish', 'Dougall')
INSERT INTO tblPurchases VALUES
(1, 'C-0001', 14.56),
(3, 'C-0002', 3.54)
SELECT * FROM tblShops
SELECT * FROM tblCustomers
SELECT * FROM tblPurchases
----