Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

/*
  Setting up our tables
  
  *Apprentices - don't worry about this code!
  
  Scroll to the part labeled "START WRITING BELOW THIS LINE"
  and work alongside the demos during class
*/

CREATE TABLE salesman (
  salesman_id INT
  ,name TEXT
  ,city TEXT
  ,commission FLOAT
);

INSERT INTO salesman
(salesman_id,name,city,commission)
VALUES
  (5001,'James Hoog','New York',0.15)
  ,(5002,'Nail Knite','Paris',0.13)
  ,(5005,'Pit Alex','London',0.11)
  ,(5006,'Mc Lyon','Paris',0.14)
  ,(5003,'Lauson Hen','',0.12)
  ,(5007,'Paul Adamn','Rome',0.13);

CREATE TABLE customer (
  customer_id INT
  ,cust_name TEXT
  ,city TEXT
  ,grade INT
  ,salesman_id INT
);

INSERT INTO customer
(customer_id,cust_name,city,grade,salesman_id)
VALUES
  (3002,'Nick Rimando','New York',100,5001)
  ,(3005,'Graham Zusi','California',200,5002)
  ,(3001,'Brad Guzan','London',NULL,5005)
  ,(3004,'Fabian Johns','Paris',300,5006)
  ,(3007,'Brad Davis','New York',200,5001)
  ,(3009,'Geoff Camero','Berlin',100,5003)
  ,(3008,'Julian Green','London',300,5002)
  ,(3003,'Jozy Altidor','Moscow',200,5007);

--#### START WRITING BELOW THIS LINE ########################################

CREATE TABLE

INSERT 0 6

CREATE TABLE

INSERT 0 8