Click to Add LocID PartID Quantity 1 1 10 2 11 22 4 4 7 5 3 6 3 5 7 1 9 4 11 9 2 2 10 4 16 11 5 1 12 5 17 13 14 14 2 20 15 1 12 16 4 17 6 18 2 19 19 1 20 3 18 21 5 1 22 4 11 23 5 6 24 2 16 25 5 32 26 3 21 27 4 2 28 1 14 29 1 11 30 5 7 31 2 10 32 3 19 33 2 4 + 34 17 No Filter Search Record: 1 of 35 LO LO + + + + + + + + + + + + Click to Add Manufacture Socket Price PartID PartType 1 CPU PartName Series TDP Ryzen 5 3600 AMD Ryzen АМ4 65 149.99 2 GPU NVIDIA EVGA 2070 RTX 125 399.99 Asrock 3 Motherboard Asrock Taichi Taichi АМ4 15 129.99 4 Power Supply EVGA Supernov: EVGA Supernova 89.99 + Gskill TridentZ FGskill TridentZ 5 RAM DDR4 90 20 6 CPU Ryzen 9 3900X AMD Ryzen АM4 105 499.99 7 CPU Ryzen 5 2600 AMD Ryzen АМ4 65 129.2 Ryzen 7 3700X AMD Ryzen 7 2700X AMD 8 CPU Ryzen АM4 65 329 9 CPU Ryzen АМ4 105 197.89 AMD 10 CPU Ryzen 3 1200 Ryzen АМ4 65 59.61 АМ4 79.87 11 CPU Ryzen 3 2200G AMD Ryzen 65 12 СPU Ryzen 3 3200G AMD Ryzen АM4 65 94.89 13 CPU Ryzen 5 1600 AMD Ryzen АМ4 65 104.9 14 CPU Ryzen 5 2400G AMD Ryzen АM4 65 119.08 15 CPU Ryzen 3 1300X AMD Ryzen АМ4 65 119.84 16 CPU Ryzen 5 1500X AMD Ryzen АМ4 65 131.87 17 CPU Ryzen 5 3400G AMD Ryzen АМ4 65 139.89 139.95 18 СPU Ryzen 6 1600X AMD Ryzen АМ4 95 19 CPU Ryzen 5 1400 AMD Ryzen АМ4 65 139.51 20 CPU Ryzen 7 1700X AMD Ryzen АМ4 65 163.85 Intel i7 7700K Intel Kaby-Lake 21 CPU LGA 1151 95 354.99 Intel i7 9700K Intel Coffee-Lake 22 CPU LGA 1151 95 419.99 23 GPU EVGA 2080 NVIDIA RTX 150 499.99 325.61 24 GPU MSI 2060 Super NVIDIA RTX 105 + GTX 102.55 25 GPU Zotac 1050ti Zotac 75 GTX 26 GPU Asus ROG 10801ASUS 450 150 Cosair Vengean Corsair 27 RAM Vengeance 15 129.77 28 Motherboard Gigabyte 450M Gigabyte 114.89 450M АM4 15 29 Motherboard 142.99 Asus Prime X47(ASUS X470 АМ4 15 30 Motherboard АМ4 MSI MPG X570 MSI X570 20 219.99 31 Power Supply + Corsair CX 650 Corsair СХ 74.99 32 Hard Disk WD Blue 1TB Western Digital Blue Western Digital Red WD Gold 12TB Western Digital Gold 49.99 33 Hard Disk WD Red 2TB 129.88 34 Hard Disk 479.54 No Filter Search Record: 1 of 35 + + + + + + + + + + + + +

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter2: Formulas, Functions, And Formatting
Section: Chapter Questions
Problem 9AYK
icon
Related questions
Question

Databse SQL Queries.

Need to write the SQL code for pulling the total cost of our inventory. We have the following 2 tables. The Parts table, which has the cost of each part, and the inventory table, which has the quantity. We need to find the total cost of our inventory. Here are pictures for reference. There are a total of 35 PartID's.

Thanks!

Click to Add
LocID
PartID
Quantity
1
1
10
2
11
22
4
4
7
5
3
6
3
5
7
1
9
4
11
9
2
2
10
4
16
11
5
1
12
5
17
13
14
14
2
20
15
1
12
16
4
17
6
18
2
19
19
1
20
3
18
21
5
1
22
4
11
23
5
6
24
2
16
25
5
32
26
3
21
27
4
2
28
1
14
29
1
11
30
5
7
31
2
10
32
3
19
33
2
4
+
34
17
No Filter Search
Record:
1 of 35
LO
LO
+
+
+
+
+
+
+
+
+
+
+
+
Transcribed Image Text:Click to Add LocID PartID Quantity 1 1 10 2 11 22 4 4 7 5 3 6 3 5 7 1 9 4 11 9 2 2 10 4 16 11 5 1 12 5 17 13 14 14 2 20 15 1 12 16 4 17 6 18 2 19 19 1 20 3 18 21 5 1 22 4 11 23 5 6 24 2 16 25 5 32 26 3 21 27 4 2 28 1 14 29 1 11 30 5 7 31 2 10 32 3 19 33 2 4 + 34 17 No Filter Search Record: 1 of 35 LO LO + + + + + + + + + + + +
Click to Add
Manufacture
Socket
Price
PartID
PartType
1 CPU
PartName
Series
TDP
Ryzen 5 3600
AMD
Ryzen
АМ4
65
149.99
2 GPU
NVIDIA
EVGA 2070
RTX
125
399.99
Asrock
3 Motherboard
Asrock Taichi
Taichi
АМ4
15
129.99
4 Power Supply
EVGA Supernov: EVGA
Supernova
89.99
+
Gskill TridentZ FGskill
TridentZ
5 RAM
DDR4
90
20
6 CPU
Ryzen 9 3900X AMD
Ryzen
АM4
105
499.99
7 CPU
Ryzen 5 2600
AMD
Ryzen
АМ4
65
129.2
Ryzen 7 3700X AMD
Ryzen 7 2700X AMD
8 CPU
Ryzen
АM4
65
329
9 CPU
Ryzen
АМ4
105
197.89
AMD
10 CPU
Ryzen 3 1200
Ryzen
АМ4
65
59.61
АМ4
79.87
11 CPU
Ryzen 3 2200G AMD
Ryzen
65
12 СPU
Ryzen 3 3200G AMD
Ryzen
АM4
65
94.89
13 CPU
Ryzen 5 1600
AMD
Ryzen
АМ4
65
104.9
14 CPU
Ryzen 5 2400G AMD
Ryzen
АM4
65
119.08
15 CPU
Ryzen 3 1300X AMD
Ryzen
АМ4
65
119.84
16 CPU
Ryzen 5 1500X AMD
Ryzen
АМ4
65
131.87
17 CPU
Ryzen 5 3400G AMD
Ryzen
АМ4
65
139.89
139.95
18 СPU
Ryzen 6 1600X AMD
Ryzen
АМ4
95
19 CPU
Ryzen 5 1400
AMD
Ryzen
АМ4
65
139.51
20 CPU
Ryzen 7 1700X AMD
Ryzen
АМ4
65
163.85
Intel i7 7700K
Intel
Kaby-Lake
21 CPU
LGA 1151
95
354.99
Intel i7 9700K
Intel
Coffee-Lake
22 CPU
LGA 1151
95
419.99
23 GPU
EVGA 2080
NVIDIA
RTX
150
499.99
325.61
24 GPU
MSI 2060 Super NVIDIA
RTX
105
+
GTX
102.55
25 GPU
Zotac 1050ti
Zotac
75
GTX
26 GPU
Asus ROG 10801ASUS
450
150
Cosair Vengean Corsair
27 RAM
Vengeance
15
129.77
28 Motherboard
Gigabyte 450M Gigabyte
114.89
450M
АM4
15
29 Motherboard
142.99
Asus Prime X47(ASUS
X470
АМ4
15
30 Motherboard
АМ4
MSI MPG X570 MSI
X570
20
219.99
31 Power Supply
+
Corsair CX 650 Corsair
СХ
74.99
32 Hard Disk
WD Blue 1TB
Western Digital Blue
Western Digital Red
WD Gold 12TB Western Digital Gold
49.99
33 Hard Disk
WD Red 2TB
129.88
34 Hard Disk
479.54
No Filter Search
Record:
1 of 35
+
+
+
+
+
+
+
+
+
+
+
+
+
Transcribed Image Text:Click to Add Manufacture Socket Price PartID PartType 1 CPU PartName Series TDP Ryzen 5 3600 AMD Ryzen АМ4 65 149.99 2 GPU NVIDIA EVGA 2070 RTX 125 399.99 Asrock 3 Motherboard Asrock Taichi Taichi АМ4 15 129.99 4 Power Supply EVGA Supernov: EVGA Supernova 89.99 + Gskill TridentZ FGskill TridentZ 5 RAM DDR4 90 20 6 CPU Ryzen 9 3900X AMD Ryzen АM4 105 499.99 7 CPU Ryzen 5 2600 AMD Ryzen АМ4 65 129.2 Ryzen 7 3700X AMD Ryzen 7 2700X AMD 8 CPU Ryzen АM4 65 329 9 CPU Ryzen АМ4 105 197.89 AMD 10 CPU Ryzen 3 1200 Ryzen АМ4 65 59.61 АМ4 79.87 11 CPU Ryzen 3 2200G AMD Ryzen 65 12 СPU Ryzen 3 3200G AMD Ryzen АM4 65 94.89 13 CPU Ryzen 5 1600 AMD Ryzen АМ4 65 104.9 14 CPU Ryzen 5 2400G AMD Ryzen АM4 65 119.08 15 CPU Ryzen 3 1300X AMD Ryzen АМ4 65 119.84 16 CPU Ryzen 5 1500X AMD Ryzen АМ4 65 131.87 17 CPU Ryzen 5 3400G AMD Ryzen АМ4 65 139.89 139.95 18 СPU Ryzen 6 1600X AMD Ryzen АМ4 95 19 CPU Ryzen 5 1400 AMD Ryzen АМ4 65 139.51 20 CPU Ryzen 7 1700X AMD Ryzen АМ4 65 163.85 Intel i7 7700K Intel Kaby-Lake 21 CPU LGA 1151 95 354.99 Intel i7 9700K Intel Coffee-Lake 22 CPU LGA 1151 95 419.99 23 GPU EVGA 2080 NVIDIA RTX 150 499.99 325.61 24 GPU MSI 2060 Super NVIDIA RTX 105 + GTX 102.55 25 GPU Zotac 1050ti Zotac 75 GTX 26 GPU Asus ROG 10801ASUS 450 150 Cosair Vengean Corsair 27 RAM Vengeance 15 129.77 28 Motherboard Gigabyte 450M Gigabyte 114.89 450M АM4 15 29 Motherboard 142.99 Asus Prime X47(ASUS X470 АМ4 15 30 Motherboard АМ4 MSI MPG X570 MSI X570 20 219.99 31 Power Supply + Corsair CX 650 Corsair СХ 74.99 32 Hard Disk WD Blue 1TB Western Digital Blue Western Digital Red WD Gold 12TB Western Digital Gold 49.99 33 Hard Disk WD Red 2TB 129.88 34 Hard Disk 479.54 No Filter Search Record: 1 of 35 + + + + + + + + + + + + +
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Single Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L