Engineering, 24.03.2020 05:21 nyceastcoast

Using SQL,
Subqueries in search conditions (within the where Clause)

1) Business case: the accounting

department would like a report of all invoice in the database that are larger than zylka design's largest invoice. Sprcifically the company, invoice data , number and total.
write a select statement that returns 4 columns: VendorName, InvoiceDate, InvoiceNumber and InvoiceTotal. Filter the results to only return records where the InvoiceTotal is more than the result(s) of the subquery.

Subquery Portion:

select the largest InvoiceTotal and filter the result to only return record(s) where VendorID is equal to 121.

Sort the result by VendorName and InvoiceTotal from largest to smallest.

Answers: 1

Show answers

Another question on Engineering

Engineering, 04.07.2019 18:10

Aplate clutch has a single pair of mating friction surfaces 250-mm od by 175-mm id. the mean value of the coefficient of friction is 0.30, and the actuating force is 4 kn. a) find the maximum pressure and the torque capacity using the uniform-wear model. b) find the maximum pressure and the torque capacity using the uniform-pressure model.

Answers: 3

Answer

Engineering, 04.07.2019 18:10

Apipe with an outside diameter of 15 cm is exposed to an ambient air and surrounding temperature of -20°c. the pipe has an outer surface temperature of 65°c and an emissivity of 0.85. if the rate of heat loss from the pipe surface is 0.95 kw per meter of length, the external convective heat transfer coefficient (h) is: (a) 12.5 w/m"k (b) 18.6 w/mk (c) 23.7 w/mk (d) 27.9 w/mk (e) 33.5 w/mk

Answers: 1

Answer

Engineering, 06.07.2019 02:30

A12 mm diameter shaft runs in a plain cylindrical bush 30 mm long that is located in an 18 mm diameter hole in a housing. the shaft-inner bush fit is h8 f and the outer bush-housing fit is h7-p6. make a fully cimensioned sketch of the bush with tolerances. find the maximum and minimum clearance or interference for both fits on the inner and outer diameters of the bush

Answers: 3

Answer

Engineering, 06.07.2019 03:10

Steel balls 12 mm in diameter are annealed by heating to 1150 k and then slowly cooled to 400 k in an air att 325 k and h -20 w/m2 k. assume the properties of the steel to be k- 40 w/m k,p 7800 kg/m3, and cp 600 j/kg k. a. determine whether lumped system method can be used to analyze this problem and if so why" b. determine the time required for the cooling process. c. determine the total amount of heat lost from each ball to the ambient air

Answers: 1

Answer

You know the right answer?

Using SQL,
Subqueries in search conditions (within the where Clause)

1) Business c...

Questions