Can you write SQL code to create this table? PartsUsed OrdNo PartNo QtyUsed 1 2
ID: 3907416 • Letter: C
Question
Can you write SQL code to create this table?
PartsUsed
OrdNo
PartNo
QtyUsed
1
2
1
1
3
4
2
3
1
2
4
5
3
2
1
3
3
2
3
4
2
3
20
2
5
5
5
5
6
5
5
8
1
5
14
1
5
16
2
6
7
1
6
8
2
7
1
2
8
1
4
8
2
1
8
3
1
8
4
1
9
9
1
9
10
4
10
4
4
11
3
2
11
4
1
12
1
4
12
7
2
13
7
1
13
8
1
14
3
6
14
6
4
14
14
1
15
4
1
15
20
1
16
9
1
16
14
1
17
7
4
17
13
1
18
1
5
18
4
6
19
8
2
20
5
2
20
7
4
21
15
1
21
16
1
21
17
3
21
18
1
22
1
5
22
2
1
23
4
2
23
16
3
23
20
2
24
3
2
25
10
1
25
13
1
26
14
1
27
4
6
27
7
4
28
19
1
29
4
1
29
9
1
30
2
1
30
3
2
30
6
6
32
8
2
PartsUsed
OrdNo
PartNo
QtyUsed
1
2
1
1
3
4
2
3
1
2
4
5
3
2
1
3
3
2
3
4
2
3
20
2
5
5
5
5
6
5
5
8
1
5
14
1
5
16
2
6
7
1
6
8
2
7
1
2
8
1
4
8
2
1
8
3
1
8
4
1
9
9
1
9
10
4
10
4
4
11
3
2
11
4
1
12
1
4
12
7
2
13
7
1
13
8
1
14
3
6
14
6
4
14
14
1
15
4
1
15
20
1
16
9
1
16
14
1
17
7
4
17
13
1
18
1
5
18
4
6
19
8
2
20
5
2
20
7
4
21
15
1
21
16
1
21
17
3
21
18
1
22
1
5
22
2
1
23
4
2
23
16
3
23
20
2
24
3
2
25
10
1
25
13
1
26
14
1
27
4
6
27
7
4
28
19
1
29
4
1
29
9
1
30
2
1
30
3
2
30
6
6
32
8
2
Explanation / Answer
CREATE TABLE PartsUsed(
OrdNo INT,
PartNo INT,
QtyUsed
);
INSERT INTO recipes
(OrdNo, PartNo, QtyUsed)
VALUES
(1, 2, 1),
(1, 3, 4),
(2, 3, 1),
(2, 4, 5),
(3, 2, 1),
(3, 3, 2),
(3, 4, 2),
(3, 20, 2),
(5, 5, 5),
(5, 6, 5),
(5, 8, 1),
(5, 14, 1),
(5, 16, 2),
(6, 7, 1),
(6, 8, 2),
(7, 1, 2),
(8, 1, 4),
(8, 2, 1),
(8, 3, 1),
(8, 4, 1),
(9, 9, 1),
(9, 10, 4),
(10, 4, 4),
(11, 3, 2),
(11, 4, 1),
(12, 1, 4),
(12, 7, 2),
(13, 7, 1),
(13, 8, 1),
(14, 3, 6),
(14, 6, 4),
(14, 14, 1),
(15, 4, 1),
(15, 20, 1),
(16, 9, 1),
(16, 14, 1),
(17, 7, 4),
(17, 13, 1),
(18, 1, 5),
(18, 4, 6),
(19, 8, 2),
(20, 5, 2),
(20, 7, 4),
(21, 15, 1),
(21, 16, 1),
(21, 17, 3),
(21, 18, 1),
(22, 1, 5),
(22, 2, 1),
(23, 4, 2),
(23, 16, 3),
(23, 20, 2),
(24, 3, 2),
(25, 10, 1),
(25, 13, 1),
(26, 14, 1),
(27, 4, 6),
(27, 7, 4),
(28, 19, 1),
(29, 4, 1),
(29, 9, 1),
(30, 2, 1),
(30, 3, 2),
(30, 6, 6),
(32, 8, 2);