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);
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.