Can you write SQL code to create this table? RepairOrder OrdNo Odometer Date VIN
ID: 3907415 • Letter: C
Question
Can you write SQL code to create this table?
RepairOrder
OrdNo
Odometer
Date
VIN
1
50000
10/5/2005
AZXS230I87
2
30000
10/5/2005
IOMEQ54397
3
6000
10/7/2005
JKLP7IIIJF
4
75000
10/8/2005
AZXS230I87
5
15000
10/10/2005
TYYYI87590
6
55000
10/10/2005
BHGY08631Q
7
25500
10/11/2005
V121BHD481
8
125000
10/12/2005
PLJFVC5609
9
60800
10/15/2005
XCVY760PIQ
10
11000
10/16/2005
THYDF55639
11
55060
10/18/2005
MNMJ7H6098
12
25600
10/20/2005
THYDF55639
13
56000
10/20/2005
QWER9LK982
14
22000
10/22/2005
QWER9LK982
15
14800
10/25/2005
JKLP7IIIJF
16
46000
10/25/2005
THYDF55639
17
71500
10/30/2005
MNMJ7H6098
18
15800
11/1/2005
MVMN8974PP
19
28525
11/2/2005
POIU980PLL
20
32560
11/2/2005
QWSA870976
21
72700
11/5/2005
IOMEQ54397
22
18900
11/8/2005
POOL98T90P
23
46590
11/8/2005
SWQW345RT6
24
34800
11/12/2005
TGVYY76R43
25
61800
11/15/2005
JHMEC3348H
26
55000
11/20/2005
V121BHD481
27
30800
11/22/2005
WWQAA452P0
28
17600
11/22/2005
XCVY760PIQ
29
20600
11/25/2005
AZXS230I87
30
22590
11/27/2005
BHGY08631Q
31
23000
2/3/2006
BHGY08631Q
32
15000
12/1/2005
BHGY08631Q
RepairOrder
OrdNo
Odometer
Date
VIN
1
50000
10/5/2005
AZXS230I87
2
30000
10/5/2005
IOMEQ54397
3
6000
10/7/2005
JKLP7IIIJF
4
75000
10/8/2005
AZXS230I87
5
15000
10/10/2005
TYYYI87590
6
55000
10/10/2005
BHGY08631Q
7
25500
10/11/2005
V121BHD481
8
125000
10/12/2005
PLJFVC5609
9
60800
10/15/2005
XCVY760PIQ
10
11000
10/16/2005
THYDF55639
11
55060
10/18/2005
MNMJ7H6098
12
25600
10/20/2005
THYDF55639
13
56000
10/20/2005
QWER9LK982
14
22000
10/22/2005
QWER9LK982
15
14800
10/25/2005
JKLP7IIIJF
16
46000
10/25/2005
THYDF55639
17
71500
10/30/2005
MNMJ7H6098
18
15800
11/1/2005
MVMN8974PP
19
28525
11/2/2005
POIU980PLL
20
32560
11/2/2005
QWSA870976
21
72700
11/5/2005
IOMEQ54397
22
18900
11/8/2005
POOL98T90P
23
46590
11/8/2005
SWQW345RT6
24
34800
11/12/2005
TGVYY76R43
25
61800
11/15/2005
JHMEC3348H
26
55000
11/20/2005
V121BHD481
27
30800
11/22/2005
WWQAA452P0
28
17600
11/22/2005
XCVY760PIQ
29
20600
11/25/2005
AZXS230I87
30
22590
11/27/2005
BHGY08631Q
31
23000
2/3/2006
BHGY08631Q
32
15000
12/1/2005
BHGY08631Q
Explanation / Answer
Create a table called RepairOrder with the column names
CREATE TABLE RepairOrder (OrdNo int, Odometer int, Date date,VIN varchar(30));
Insert data into the table, RepairOrder
INSERT INTO RepairOrder (OrdNo, Odometer, Date,VIN)
VALUES
(1,50000,’10/5/2005’,’ AZXS230I87’),
(2,30000,’10/05/2005’,’ IOMEQ54397’),
(3,6000,’10/07/2005’,’JKLP7IIIJF’),
(4,75000,’10/08/2005 ’,’AZXS230I87’),
(5,15000,’10/10/2005’,’TYYYI87590’),
(6,55000,’10/10/2005’,’BHGY08631Q’),
(7,25500,’10/11/2005’,’V121BHD481’),
(8,125000,’10/12/2005’,’PLJFVC5609’),
(9,60800,’10/15/2005’,’XCVY760PIQ’),
(10,11000,’10/16/2005’,’THYDF55639’),
(11,55060,’10/18/2005’,’MNMJ7H6098’),
(12,25600,’10/20/2005 ’,’THYDF55639’),
(13,56000,’10/20/2005’,’QWER9LK982’),
(14,22000,’10/22/2005’,’QWER9LK982’),
(15,14800,’10/25/2005’,’JKLP7IIIJF’),
(16,46000,’10/25/2005’,’THYDF55639’),
(17,71500,’10/30/2005’,’MNMJ7H6098’),
(18,15800,’11/01/2005’,’MVMN8974PP’),
(19,28525,’11/02/2005’,’POIU980PLL’),
(20,32560,’11/02/2005’,’QWSA870976’),
(21,72700,’11/05/2005’,’IOMEQ54397’),
(22,18900,’11/08/2005’,’POOL98T90P’),
(23,46590,’11/08/2005’,’SWQW345RT6’),
(24,34800,’11/12/2005’,’TGVYY76R43’),
(25,61800,’11/15/2005’,’JHMEC3348H’),
(26,55000,’11/20/2005’,’V121BHD481’),
(27,30800,’11/22/2005’,’WWQAA452P0’),
(28,17600,’11/22/2005 ’,’XCVY760PIQ’),
(29,20600,’11/25/2005’,’AZXS230I87’),
(30,22590,’11/27/2005’,’BHGY08631Q’),
(31,23000,’02/03/2006’,’BHGY08631Q’),
(32,15000,’12/01/2005’,’BHGY08631Q’);
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.