Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need Help in SQL Exercise is had got the first answer but i nedd rest of them 1-->List slRepair.RepairID AS RepairNum, slRepair.RepairDate, slRepair.RepairCost for all

Need Help in SQL Exercise is had got the first answer but i nedd rest of them

1-->List slRepair.RepairID AS RepairNum, slRepair.RepairDate, slRepair.RepairCost for all repairs in slRepair. For this report, use aliases to list RepairID as RepairNum and RepairCost as Cost.

Sample answer--> SELECT slRepair.RepairID AS RepairNum, slRepair.RepairDate, slRepair.RepairCost As Cost FROM slRepair

2-->List slMaintenance.MaintenanceID and slMaintenance.Description for all rows in slMaintenance. For this report, use an alias to list slMaintenance.Description as MaintenanceDesc.

3-->List slGasPurchase.GasPurchaseID, slGasPurchase.Gallons, and slGasPurchase.CostPerGallon for all rows in slGasPurchase. For this report, use an alias to list slGasPurchase.Gallons AS GallonsOfGas.

4-->List slTrip.TripID, slTrip.TripStart, slTrip.WaterTemp for all rows in slTrip. For this report, use an alias to list slTrip.TripStart as StartOfTrip.

5-->For repairs with SupplierID = 1502, list slRepair.RepairID, slRepair.RepairCost, slRepair.SupplierID. Order the list by RepairCost in ascending order.

6-->Produce a list of unique slRepair.RepairCost(s) for all rows in slRepair.

7-->Produce a list of unique slTrip.WaterTemp(s) for all rows in slTrip.

8-->List slRepair.RepairCost and slRepair.Description for all rows in slRepair. For this report, alias slRepair.Description as MaintenanceDesc. Order the list by RepairCost in descending order. This ordering will show the most expensive repairs first.

9-->List slTrip.TripStart and slTrip.WaterTemp for all rows in slTrip. For this report, alias slTrip.TripStart as StartOfTrip. Order the list by WaterTemp in descending order.

10-->List slRepair.SupplierID,slRepair.RepairCost and slRepair.Description for all rows in slRepair. For this report, alias slRepair.Description as MaintenanceDesc. Order the list first by SupplierID in ascending order and then by RepairCost in descending order.

11-->List slTrip.LaunchID, slTrip.TripStart, and slTrip.WaterTemp for all rows in slTrip. For this report, alias slTrip.TripStart as StartOfTrip. Order the list first by LaunchID in Descending order and then by WaterTemp in ascending order.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions