(Solved) : Example List Slgearpurchasegearpurchaseid Slgearpurchasepurchaseamount Slgearpurchasedescr Q26268256 . . .
THIS IS AN EXAMPLE : List slGearPurchase.GearPurchaseID,slGearPurchase.PurchaseAmount, slGearPurchase.Description for allgear purchases.
Replace NULL values in Description with NA (Not Applicable).
Order the list by slGearPurchase.GearPurchaseID in ascendingorder.
ANSWER TO THE EXAMPLE :
SELECT slGearPurchase.GearPurchaseID,slGearPurchase.PurchaseAmount,
isNULL (slGearPurchase.Description,’NA (Not Applicable)’) ASDescription
FROM slGearPurchase
ORDER by slGearPurchase.GearPurchaseID ASC
NEED HELP WITH THOSE QUESTIONS 1-3
(1) For repairs having supplierID 1501 OR 1517 OR 1518, listslRepair.RepairDate, slRepair.RepairCost, slRepair.SupplierID.
Write this query using IN().
Order the list first by SupplierID in ascending order and then byrepair cost in descending order.
(2) List slPax.PaxID, slPax.PaxFirstName, andslPax.PaxLastName for passengers with lastname Clark OR Sharma ORPatel.
Write this query using IN().
Order the list by PaxID in ascending order.
(3) List slSupplier.SupplierID andslSupplier.SupplierName for suppliers whose SupplierID is unequal<> to 1502 AND 1506 AND 1510 AND 1512 AND 1518.
Order the list by slSupplier.SupplierID in ascending order.
Expert Answer
Answer to Example List Slgearpurchasegearpurchaseid Slgearpurchasepurchaseamount Slgearpurchasedescr Q26268256 . . .
OR