Can you write SQL code to create this table? Vehicle VIN Year Make Model License
ID: 3907414 • Letter: C
Question
Can you write SQL code to create this table?
Vehicle
VIN
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
TGVYY76R43
1995
Honda
Civic
980QAW
WA
4
15
THYDF55639
2000
Ford
F-100
980QEW
WA
8
5
TYYYI87590
2002
Toyota
Celica
890YUI
ID
6
6
V121BHD481
1999
Toyota
Pick-up
190PGF
WA
6
9
VHJK009L88
1997
Ford
Taurus
456MNO
WA
4
13
WWQAA452P0
1996
Buick
Regal
123DEF
WA
8
10
XCVY760PIQ
2000
Toyota
Celica
477HSD
WA
4
8
Part
PartNo
PartDesc
UnitsInStock
UnitPrice
UnitSize
1
10W-40 oil
145
$1.00
quart
2
oil filter
14
$2.00
item
3
Antifreeze
10
$3.95
quart
4
Spark Plugs
45
$0.99
item
5
Transmission Fluid
15
$1.50
quart
6
10W-30 oil
95
$0.95
quart
7
Brake Lining
25
$5.00
quart
8
Shock
75
$6.00
item
9
Muffler
10
$15.00
item
10
Tail Pipe
85
$4.00
item
11
Head Gasket
32
$9.00
dozen
12
Timing Chain
6
$22.50
item
13
Battery
13
$55.00
item
14
Radiator
3
$60.00
item
15
Radiator Hose
24
$3.00
dozen
16
Rotor
4
$16.00
item
17
Tire
36
$46.00
item
18
Headlight
6
$5.00
case
19
Tail Light
7
$3.00
dozen
20
Gearbox
2
$25.00
item
Vehicle
VIN
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
TGVYY76R43
1995
Honda
Civic
980QAW
WA
4
15
THYDF55639
2000
Ford
F-100
980QEW
WA
8
5
TYYYI87590
2002
Toyota
Celica
890YUI
ID
6
6
V121BHD481
1999
Toyota
Pick-up
190PGF
WA
6
9
VHJK009L88
1997
Ford
Taurus
456MNO
WA
4
13
WWQAA452P0
1996
Buick
Regal
123DEF
WA
8
10
XCVY760PIQ
2000
Toyota
Celica
477HSD
WA
4
8
Explanation / Answer
Answer)
Table Vehicle created:
CREATE TABLE Vehicle(VIN varchar, Year int, Make varchar, Model varchar, LicenseNo varchar, State varchar, Cylinders int, CustNo int);
Sample value entered:
insert into Vehicle values('AZXS230I87',2001,'Ford','Skylark','145UKI','WA',4,10);
Table Part created:
CREATE TABLE Part (PartNo int, PartDesc varchar, UnitsInStock int, UnitPrice varchar, UnitSize varchar);
Sample value entered:
insert into Part values (1,'10W-40 oil',145,'$1.00','quart');
select * from Vehicle;
Output:
AZXS230I87|2001|Ford|Skylark|145UKI|WA|4|10
select * from Part;
Output:
1|10W-40 oil|145|$1.00|quart
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.