I need the SQL queries for each problem.

Work with Product table in the file tab on Canvas.

1. If industrystandardcost is greater than $300, print it expensive item along with product id, product name and the cost. Otherwise print it not expensive.
2. If industrystandardcost is greater than $200 but less than $1000, print it 200-1000 along with product id, product name and the cost. Otherwise print it not 200-1000.
3. If product name includes dresser and category is furniture, then print it dresser&furniture along with product id, product name, category. Otherwise print it not dresser&furniture.
4. Display category that are greater than $100 in average in industrystandardcost along with category.
5. Display category that are greater than 10 in count.

- Click to Add- Product X ProductID - ProductName - IndustryStandardCost - Category 2 Economy Mattress & Box Set $279.50 Furniture 3 Standard Mattress & Box Set $769.25 Furniture 4 Luxury Mattress Set & Box Set $2,012.00 Furniture 5 Smart Foam & Box Set $3,265.00 Furniture 6 Classic Headboard/Frame $126.50 Furniture 7 Decorative Headboard/Frame $189.75 Furniture 8 Contemporary Headboard/Frai $189.75 Furniture 9 Rustic Headboard/Frame $158.13 Furniture 10 Artist Designed Headboard/Fr $253.00 Furniture 11 Classic Dresser $126.50 Furniture 12 Decorative Dresser $189.75 Furniture 13 Contemporary Dresser $189.75 Furniture 14 Rustic Dresser $158.13 Furniture 15 Artist Designed Dresser $253.00 Furniture 16 Classic Armoire $253.00 Furniture 17 Decorative Armoire $379.50 Furniture 18 Contemporary Armoire $379.50 Furniture 19 Rustic Armoire $316.25 Furniture 20 Artist Designed Armoire $506.00 Furniture 21 19" Tube Television $158.13 Accessories 22 27" Tube Television $265.65 Accessories 23 26" Flat Panel Television $790.63 Accessories 24 37" Flat Panel Television $595.00 Accessories 25 50" Flat Panel Television $1,428.80 Accessories 26 63" Flat Panel Television $2,392.60 Accessories 27 Alarm Clocks $18.98 Accessories 28 Handmade Cuckoo Clock $101.20 Accessories 29 Handmade Mantle Clock $202.40 Accessories 30 Grandfather Clock $1,518.00 Accessories 31 Basic Home Theater System $531.30 Accessories 32 Premium Home Theater Syster $2,631.20 Accessories 33 Ultimate Home Theater Systen $4,212.45 Accessories 34 ProAccoustics System w/Instal $5,313.00 Accessories 35 Classic Lamps $63.25 Accessories 36 Decorative Lamps $94.88 Accessories 37 Contemporary Lamps $94.88 Accessories 38 Artist Designed Lamps $126.50 Accessories 39 Rustic Lamps $75.90 Accessories 40 Basic Chandelier $227.70 Accessories 41 Elaborate Chandelier $986.70 Accessories 42 Royal Chandelier $2,201.10 Accessories 43 Basic Iron $18.98 Accessories 44 Deluxe Iron $37.95 Accessories 45 Basic Hair Blow Dryer $18.98 Accessories 46 Deluxe Hair Blow Dryer $37.95 Accessories 47 Framed Print Pictures $253.00 Accessories 48 Oil Paintings $506.00 Accessories 49 Blown Glass Sculptures $379.50 Accessories 50 Standard Bed sheets $101.20 Linens 51 Custom Bed sheets $151.80 Linens 52 Standard Towels $94.88 Linens 53 Custom Towels $142.31 Linens 54 Standard Curtains $126.50 Linens 55 Custom Curtains $289.75 Linens 56 Standard Uniforms $75.90 Clothing 57 Custom Uniforms $113.85 Clothing 58 Custom Embroidered Blazers $101.20 Clothing (New)