bd1GntSn

1--Dropping tables clear out any existing data
2DROP TABLE IF EXISTS automobiles;
3
4CREATE TABLE automobiles(
5    id INTEGER PRIMARY KEY,
6    make VARCHAR(15)NOT NULL,
7    model VARCHAR(20)NOT NULL,
8    year INTEGER NOT NULL,
9    owner CHAR(25) NOT NULL,
10    msrp DECIMAL NOT NULL,
11    purchase_date DATE NOT NULL
12);
13
14
15
16INSERT INTO automobiles(id, make, model, year, owner, msrp, purchase_date) VALUES(
17    1,
18    'Ferarri',
19    'F40',
20    '1987',
21    '',
22    '1690000',
23    '3/12/2019');
24INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date)VALUES(
25    2,
26    'Tundra',
27    '4X2',
28    '2019',
29    '',
30    '39625',
31    '3/12/2019');
32INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date) VALUES(
33    3,
34    'Mercedes-Benz',
35    'AMG GT',
36    '2014',
37    '',
38    '145000',
39    '3/12/2019');
40INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date)VALUES(
41    4,
42    'Chrysler',
43    '300',
44    '2004',
45    '',
46    '800',
47    '3/12/2019');
48INSERT INTO automobiles(id, make, model, year,owner, msrp, purchase_date) VALUES(
49    5,
50    'Jeep',
51    'Wrangler',
52    '2019',
53    '',
54    '33695',
55    '3/12/2019');
56
57SELECT make, model, year, msrp FROM automobiles ORDER BY year ASC;
58
59UPDATE automobiles
60SET owner = 'Deanna Slotegraaf'
61WHERE make = 'ferarri';
62
63DELETE FROM automobiles WHERE make = 'Chrysler';