Module 2, hands-on lab, five basic queries.txt

DROP TABLE instructor;

CREATE TABLE instructor(
ins_id INTEGER PRIMARY KEY NOT NULL,
lastname VARCHAR(15)  NOT NULL,
firstname VARCHAR(15) NOT NULL,
city VARCHAR(15),
country CHAR(2)
);

INSERT INTO instructor
  (ins_id, lastname, firstname, city, country)
  VALUES 
  (1, 'Ahuja', 'Rav', 'Toronto', 'CA')
;

INSERT INTO instructor
  VALUES
  (2, 'Chong', 'Raul', 'Toronto', 'CA'),
  (3, 'Vasudevan', 'Hima', 'Chicago', 'US')
;

SELECT * FROM instructor;

SELECT firstname, lastname, country from instructor where city='Toronto';

UPDATE instructor SET city='Markham' where ins_id=1;

SELECT * FROM INSTRUCTOR ;