summaryrefslogtreecommitdiff
path: root/labs/2/run.sql
diff options
context:
space:
mode:
authormo khan <mo.khan@gmail.com>2020-01-01 11:15:15 -0700
committermo khan <mo.khan@gmail.com>2020-01-01 11:15:15 -0700
commita8f03a5dc9b92950a06fb79da6af5eb3ef7844ae (patch)
treeb4e1b72c699cb03addc04ff02c6170d1f5667738 /labs/2/run.sql
parent96828284a572a0d14c7565fe1c41b7b7f525e2db (diff)
Identify tasks to complete
Diffstat (limited to 'labs/2/run.sql')
-rw-r--r--labs/2/run.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/labs/2/run.sql b/labs/2/run.sql
index b0e0fc7..01355ae 100644
--- a/labs/2/run.sql
+++ b/labs/2/run.sql
@@ -14,9 +14,9 @@ CREATE TABLE employees (
INSERT INTO employees VALUES ('Harris', 'T', 'Chomsky', 123, '1965-12-10', 'Edmonton', 'M', 50000, 12);
INSERT INTO employees VALUES ('Kristian', 'C', 'Bohr' , 456, '1975-10-05', 'Ottawa', 'M', 28000, 11);
INSERT INTO employees VALUES ('Charlotte', 'F', 'Bouchard' , 789, '1985-08-06', 'Montreal', 'F', 40000, 11);
-INSERT INTO employees VALUES ('Said', 'J', 'Ahmad', 111, '1970-09-07', 'Toronto', M, 30000, 12);
-INSERT INTO employees VALUES ('Andrew', 'U', 'Brahe', 222, '1970-04-02', 'Winnipeg', M, 20000, 10);
-INSERT INTO employees VALUES ('Nadia', 'O', 'Mamary', 333, '1960-01-08', 'Saskatoon', F, 35000, 10);
+INSERT INTO employees VALUES ('Said', 'J', 'Ahmad', 111, '1970-09-07', 'Toronto', 'M', 30000, 12);
+INSERT INTO employees VALUES ('Andrew', 'U', 'Brahe', 222, '1970-04-02', 'Winnipeg', 'M', 20000, 10);
+INSERT INTO employees VALUES ('Nadia', 'O', 'Mamary', 333, '1960-01-08', 'Saskatoon', 'F', 35000, 10);
INSERT INTO employees VALUES ('Yuan', 'P', 'Nielsen', 987, '1983-02-27', 'Moncton', 'F', 32000, 11);
INSERT INTO employees VALUES ('Neil', 'A', 'Dion', 654, '1953-02-27', 'Moncton', 'M', 32000, 11);
INSERT INTO employees VALUES ('Karen', 'C', 'Ming', 321, '1963-11-16', 'Victoria', 'F', 26000, 12);