(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