SQL query to display product name and list price (Prod_sell) in product type Sleeping Bag which has the list price less than the lowest list price in ANY product type.
Sort the output by top list prices first and then by the product name.
PRODUCTS 1 PROD_NO I PROD_LINE I PROD_TYPE 1 PROD_NAME O PROD_COST PROD_SELL I STATUS O PICTURE 11 SALES_2016 I SALES_2015 M SALES_2014 SALES_2013 I SID PROD_COST 3 4 130 343 370 410 80 86 56 5 7 11 12 13 14 15 16 17 431 PROD_NO PROD_LINE PROD_TYPE PROD_NAME 1 40100 Outdoor Products Tents Star Lite 2 40101 Outdoor Products Tents Star Gazer-2 40102 Outdoor Products Tents Star Gazer-3 40103 Outdoor Products Tents Star Dome 40200 Outdoor Products Sleeping Bags MoonBeam 6 40201 Outdoor Products sleeping Bags Moonglow 40202 Outdoor Products Sleeping Bags MoonLite 8 40300 Outdoor Products Back Packs Day Tripper 9 40301 Outdoor Products Back Packs Pack n' Hike 10 40302 Outdoor Products Back Packs GO Small Waist Pack 40303 Outdoor Products Back Packs GO Large Waist Pack 40400 Outdoor Products Cooking Equipment Dover-1 40401 Outdoor Products Cooking Equipment Dover-2 40402 Outdoor Products Cooking Equipment Go Cookset 40403 Outdoor Products Cooking Equipment GO Camp Kettle 50100 GO Sport Line Carry-Bags GO Sport Bag 50101 GO Sport Line Carry-Bags GO Ski Gear Bag 50102 GO Sport Line Carry-Bags GO Duffel Bag 19 50201 GO Sport Line Sport Wear GO Headband 50202 GO Sport Line Sport Wear GO Wristband 50203 GO Sport Line Sport Wear GO Water Bottle 60100 Environmental Line Alert Devices Pocket U.V. Alerter 23 60101 Environmental Line Alert Devices Microwave Detective 60102 Environmental Line Alert Devices Pocket Radon Alerter 25 60200 Environmental Line Recycled Products Envirosak 60201 Environmental Line Recycled Products Enviro-Kit 27 60202 Environmental Line Recycled Products Enviro-T 60300 Environmental Line Bio-Friendly s... RiverKind Shampoo 29 60301 Environmental Line Bio-Friendly s... RiverKind Soap 60302 Environmental Line Bio-Friendly s... RiverKind Detergent 60400 Environmental Line Sunblock Sun Shelter-8 60401 Environmental Line Sunblock Sun Shelter-15 60402 Environmental Line Sunblock Sun Shelter-30 60500 Environmental Line Water Purifiers Pro-Lite Water Filter 60501 Environmental Line Water Purifiers Pocket Water Filter 88 2 16 43 74 36 14 14 16 28 5 4 4 3 4 13 2 4 PROD_SELL STATUS PICTURE 165 A P40100 518 A P40101 555 A P40102 615 A P40103 120A P40200 129A P40201 84A P40202 14A P40300 131A P40301 18 A P40302 24 A P40303 65 A P40400 111A P40401 54A P40402 21A P40403 28 A P50100 32 A P50101 56A P50102 10A P50201 8A P50202 8A P50203 9A P60100 12A P60101 39A P60102 6A P60200 12 A P60201 30A P60202 9A P60300 11 A P60301 6A P60302 6A P60400 9A P60401 9A P60402 165 A P60500 270A P60501 SALES_2016 SALES_2015 : 35310 85714 18 630 31671 37740 47952 26445 31550 14640 8778 16383 7476 8820 6623 810 978 2882 5502 1890 1418 2448 2822 27671 32914 23976 7226 17928 12077 8631 6593 8120 17802 22720 22669 24976 41935 4190 6072 3848 7700 4872 8416 2700 5811 1296 6389 7098 20549 816 1162 1764 1993 7650 7689 1512 31118 12915 39913 7392 19935 7218 7950 14040 28204 5400 23963 11220 26186 14850 32292 18 20 21 22 24 26 28 30 31 32 . 33 34 35
