You are writing SQL select statement for it. the table is called Fudgemart_products

this is the fudgemart product table

3.1) How many Fudgemart products in each department have a retail price that is greater than the average selling price of all products in Fudgemart? Also, display the average price of all products in the department, like so: Show your code here: Show your results set w/ SYSTEM_USER here: 1 2600 2601 /** LAB 5 31 / romatroducts 100% Results Messages product id product department product name 3 Hardware Rip Cew Hammer 2 4 Oishing DHR Tee 3 5 Gothing Running Parts 4 6 Clothing Wool Socks 5 7 Gothing Squeaky Snels 8 Gothing Cool Jeans 7 9 Gothing Denim Jacket 8 10 Oothing Leather Jacket 9 Clothing Courdory Parts 10 12 Query executed successfully, product_petal pace product wholesale prin product is active product_add_date product vendor de product_desc 19.95 1200 2007-08-31 1742447033 NULL 20.00 800 2007-09-14 17.1345 553 2 NULL 35.00 12.00 2007-09-14 17.1404432 NULL 8.00 200 2007-09-14 17. 1420 1172 NULL 65 00 2000 2007-05-14 17:14-43.270 2 NULL 15.00 1000 2007-09-14 17:1507 8037 NULL 6000 1500 2007-09-14 17 15 20 6307 NULL 95.00 4500 2007-09-14 17:15 303677 NULL 24.00 12.00 2007-09-15 22.43.13 2277 NULL 29 300 2017.15.2242972 dblabuschool vyr.edu (1 In 2601 Col1 Ch 1 INS Ready Tyne here in search