Can you write SQL code to create this table? Vehicle VIN (pk) Year Make Model Li
ID: 3907412 • Letter: C
Question
Can you write SQL code to create this table?
Vehicle
VIN (pk)
Year
Make
Model
LicenseNo
State
Cylinders
CustNo
AZXS230I87
2001
Ford
Skylark
145UKI
WA
4
10
BHGY08631Q
1998
Chevrolet
Blazer
567WER
WA
8
7
GHL39789UI
1993
Honda
Del Sol
123XYZ
WA
4
13
IOMEQ54397
2000
Buick
Regal
367ASZ
WA
8
2
JHMCCF673Q
1992
Honda
Civic Si
367ABC
WA
4
8
JHMEC3348H
1985
Buick
Corolla
345XYZ
WA
6
5
JKLP7IIIJF
2001
Ford
Impala
902PLO
WA
8
2
LPQW76200I
2000
Honda
Accord
123ABC
MT
4
7
MNMJ7H6098
1999
Lincoln
Towne Car
234ABC
WA
8
12
MVMN8974PP
1998
Honda
Civic DX
567TUV
WA
4
9
PLJFVC5609
1997
Toyota
Landcruiser
876GYK
WA
4
16
POIU980PLL
2001
Chevrolet
Cavalier
675THE
OR
4
3
POOL98T90P
1998
Ford
Escort
678RST
WA
4
11
QWER9LK982
1999
Pontiac
FireHawk
669GVI
WA
8
1
QWSA870976
2000
Chevrolet
Cavalier
116UYT
WA
4
14
SWQW345RT6
1999
BMW
320i
789GHI
CA
6
4
Vehicle
VIN (pk)
Year
Make
Model
LicenseNo
State
Cylinders
CustNo
AZXS230I87
2001
Ford
Skylark
145UKI
WA
4
10
BHGY08631Q
1998
Chevrolet
Blazer
567WER
WA
8
7
GHL39789UI
1993
Honda
Del Sol
123XYZ
WA
4
13
IOMEQ54397
2000
Buick
Regal
367ASZ
WA
8
2
JHMCCF673Q
1992
Honda
Civic Si
367ABC
WA
4
8
JHMEC3348H
1985
Buick
Corolla
345XYZ
WA
6
5
JKLP7IIIJF
2001
Ford
Impala
902PLO
WA
8
2
LPQW76200I
2000
Honda
Accord
123ABC
MT
4
7
MNMJ7H6098
1999
Lincoln
Towne Car
234ABC
WA
8
12
MVMN8974PP
1998
Honda
Civic DX
567TUV
WA
4
9
PLJFVC5609
1997
Toyota
Landcruiser
876GYK
WA
4
16
POIU980PLL
2001
Chevrolet
Cavalier
675THE
OR
4
3
POOL98T90P
1998
Ford
Escort
678RST
WA
4
11
QWER9LK982
1999
Pontiac
FireHawk
669GVI
WA
8
1
QWSA870976
2000
Chevrolet
Cavalier
116UYT
WA
4
14
SWQW345RT6
1999
BMW
320i
789GHI
CA
6
4
Explanation / Answer
If you have any doubts, please give me comment...
CREATE TABLE Vehicle(
VIN CHAR(10) NOT NULL PRIMARY KEY,
Year INTEGER,
Make VARCHAR(20),
Model VARCHAR(20),
LicenceNo CHAR(6),
State CHAR(2),
Cylinders INTEGER,
CustNo INTEGER
);
INSERT INTO Vehicle VALUES('AZXS230I87', '2001', 'Ford', 'Skylark', '145UKI', 'WA', '4', '10');
INSERT INTO Vehicle VALUES('BHGY08631Q', '1998', 'Chevrolet', 'Blazer', '567WER', 'WA', '8', '7');
INSERT INTO Vehicle VALUES('GHL39789UI', '1993', 'Honda', 'Del Sol', '123XYZ', 'WA', '4', '13');
INSERT INTO Vehicle VALUES('IOMEQ54397', '2000', 'Buick', 'Regal', '367ASZ', 'WA', '8', '2');
INSERT INTO Vehicle VALUES('JHMCCF673Q', '1992', 'Honda', 'Civic Si', '367ABC', 'WA', '4', '8');
INSERT INTO Vehicle VALUES('JHMEC3348H', '1985', 'Buick', 'Corolla', '345XYZ', 'WA', '6', '5');
INSERT INTO Vehicle VALUES('JKLP7IIIJF', '2001', 'Ford', 'Impala', '902PLO', 'WA', '8', '2');
INSERT INTO Vehicle VALUES('LPQW76200I', '2000', 'Honda', 'Accord', '123ABC', 'MT', '4', '7');
INSERT INTO Vehicle VALUES('MNMJ7H6098', '1999', 'Lincoln', 'Towne Car', '234ABC', 'WA', '8', '12');
INSERT INTO Vehicle VALUES('MVMN8974PP', '1998', 'Honda', 'Civic DX', '567TUV', 'WA', '4', '9');
INSERT INTO Vehicle VALUES('PLJFVC5609', '1997', 'Toyota', 'Landcruiser', '876GYK', 'WA', '4', '16');
INSERT INTO Vehicle VALUES('POIU980PLL', '2001', 'Chevrolet', 'Cavalier', '675THE', 'OR', '4', '3');
INSERT INTO Vehicle VALUES('POOL98T90P', '1998', 'Ford', 'Escort', '678RST', 'WA', '4', '11');
INSERT INTO Vehicle VALUES('QWER9LK982', '1999', 'Pontiac', 'FireHawk', '669GVI', 'WA', '8', '1');
INSERT INTO Vehicle VALUES('QWSA870976', '2000', 'Chevrolet', 'Cavalier', '116UYT', 'WA', '4', '14');
INSERT INTO Vehicle VALUES('SWQW345RT6', '1999', 'BMW', '320i', '789GHI', 'CA', '6', '4');
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.