THIS IS AN EXAMPLE : List slGearPurchase.GearPurchaseID, slGearPurchase.PurchaseAmount, slGearPurchase.Description for all gear purchases. Replace NULL values in Description with NA (Not Applicable). Order the list by slGearPurchase.GearPurchaseID in ascending order.

ANSWER TO THE EXAMPLE : SELECT slGearPurchase.GearPurchaseID, slGearPurchase.PurchaseAmount, isNULL (slGearPurchase.Description,'NA (Not Applicable)') AS Description FROM slGearPurchase ORDER by slGearPurchase.GearPurchaseID ASC

NEED HELP WITH THOSE QUESTIONS 1-3

(1) For repairs having supplierID 1501 OR 1517 OR 1518, list slRepair.RepairDate, slRepair.RepairCost, slRepair.SupplierID.

Write this query using IN(). Order the list first by SupplierID in ascending order and then by repair cost in descending order.

(2) List slPax.PaxID, slPax.PaxFirstName, and slPax.PaxLastName for passengers with lastname Clark OR Sharma OR Patel. Write this query using IN(). Order the list by PaxID in ascending order.

(3) List slSupplier.SupplierID and slSupplier.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.