Engineering, 24.03.2020 05:37 Ilikepandas2019
The purpose of this assignment is to design and implement queries that will assist in developing answers to business problems. For this assignment, continue to operate in the role of a data analyst at Adventure Works Cycles company. Based upon "LL Road Frame-Black 60" scenario and questions formulated for the Topic 3 assignment, write queries for the "AdventureWorks 2016" database using SQL Server 2016 Developer Edition. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy. Create a Word document that includes the SQL queries used to explore the database tables, and answer the following questions.
Find the product ID for the LL Road Frame – Black 60.
Find the listing price of the LL Road Frame – Black 60.
How would you rewrite the query used in question 2 to exclude NULL values?
How many orders have been placed for LL Road Frame – Black 60?
Rename the OrderQty to Quantity in your results.
Answers: 2
Engineering, 04.07.2019 18:10
Apump is used to circulate hot water in a home heating system. water enters the well-insulated pump operating at steady state at a rate of 0.42 gal/min. the inlet pressure and temperature are 14.7 lbf/in.2, and 180°f, respectively; at the exit the pressure is 60 lbf/in.2 the pump requires 1/15 hp of power input. water can be modeled as an incompressible substance with constant density of 60.58 lb/ft3 and constant specific heat of 1 btu/lb or. neglecting kinetic and potential energy effects, determine the temperature change, in °r, as the water flows through the pump.
Answers: 1
Engineering, 04.07.2019 18:10
Air is to be cooled in the evaporator section of a refrigerator by passing it over a bank of 0.8-cm-outer-diameter and 0.4-m-long tubes inside which the refrigerant is evaporating at -20°c. air approaches the tube bank in the normal direction at 0°c and 1 atm with a mean velocity of 4 m/s. the tubes are arranged in-line with longitudinal and transverse pitches of sl- st 1.5 cm. there are 30 rows in the flow direction with 15 tubes in each row. determine (a) the refrigeration capacity of this system and (b) pressure drop across the tube bank. evaluate the air properties at an assumed mean temperature of -5°c and 1 atm. is this a good assumption?
Answers: 1
Engineering, 04.07.2019 18:10
Coiled springs ought to be very strong and stiff. si3n4 is a strong, stiff material. would you select this material for a spring? explain.
Answers: 2
Engineering, 04.07.2019 18:10
An air compression refrigeration system is to have an air pressure of 100 psia in the brine tank and an allowable air temperature increase of 60°f for standard vapor compression cycle temperatures of 77 f entering the expansion cylinder and 14 f entering the compression cylinder, calculate the coefficient of performance a. 2.5 b 3.3 c. 4.0 d. 5.0
Answers: 3
The purpose of this assignment is to design and implement queries that will assist in developing ans...
Arts, 25.02.2021 23:20
Mathematics, 25.02.2021 23:20
Chemistry, 25.02.2021 23:20
Mathematics, 25.02.2021 23:20
Physics, 25.02.2021 23:20
Geography, 25.02.2021 23:20
Mathematics, 25.02.2021 23:20
Mathematics, 25.02.2021 23:20
English, 25.02.2021 23:20
English, 25.02.2021 23:20