How to do solve the problems with the table data below?

Please note: if the answer is a SELECT statement, print the statement and the output; if the answer is an INSERT, UPDATE, or DETELE statement, print the statement and, the data before and after the statement is run.

1. Find all line items that are higher in price than all those sold by Mary Halvorson.

Table data:

mysql> select from customer; +-------+- | Ename | LName | AcctNum +--- | Heidi | Wonder | 4552 | Sam | Goodwin | 3679 | Marge | Toledo | 1234 | Frank James | 5623 +-------+- 4 rows in set (0.00 sec) mysql> select * from orders; +------- | AcctNum | OrderNum OrderDate StoreNum Sales RepNum +----- -+----- | 4552 3 | 2004-01-03 | 1 11 | 3679 6 2004-01-05 1 | 1 | 1234 7 2004-01-07 1 | 2 | 5623 8 2004-01-09 1 12 | 4552 9 | 2004-01-11 | 1 13 | 3679 10 | 2004-01-13 | 1 3 | 1234 11 | 2004-01-15 | 1 | 1 15623 12 | 2004-01-17 | 1 | 2 | 4552 13 | 2004-01-19 | 1 13 | 3679 14 | 2004-01-21 | 1 3 | 1234 15 | 2004-01-23 1 | 2 | 5623 16 | 2004-01-25 | 1 11 | 4552 17 | 2004-01-27 1 | NULL +-- 13 rows in set (0.00 sec) mysql> select * from order_detail; +- ----- | OrderNum LineNum ProdNum | Qty | Color Unit Price - I | 1 1 1 31 1 | Bike28A 61 1 Bike28A 71 1 | Bike28A 1 | Bike28B 2 ridinggloves 91 1 Bike28B 101 1 | Bike28B 11 1 | Moped77 12 1 Bike31A 12 | 2 Helmet 13 | 1 Bike 31A 14 1 1 Bike28 15 | 1 | Bike28 Cruiser 16 | 1 | Bike28Schwinn 171 1 SchwinBike28Mountain +- 15 rows in set (0.00 sec) 1 | Red 2 Blue NULL | Green 3 Red 7 | White 2 Blue 5 | Green 1 | Black 1 | Red 4 | Red 1 | Blue 1 | Orange 3 | White 1 | Red 2 | Blue 300.00 259.00 525.00 455.00 60.00 255.00 199.00 955.00 525.00 75.00 455.00 255.00 199.00 955.00 855.00 + 1 | 1 1 1 1 1 1 | mysql> select * from product; | ProdNum | ProdName | ProdSupy | ColorGrp ProdCost +--- | Bike28 | standard29InBike | Generic | 8colors | NULL Bike28A | Trek 28 InBike | Trek | 8colors 1 NULL | Bike28B | Speedo 28 InBike | Speedo | 8colors 1 NULL Bike28Cruiser | Cruiser 28InBike | AmBike | 8colors NULL Bike28 Schwinn | Schwinn29InBike | Schwinn | 8colors 1 NULL Bike31A | Trek31InBike | Trek | 8colors NULLI Helmet i standardhelmet | AmManuf | RWB 1 NULL Moped77 | Moped77KPN | KPNEnterprise | WhtBlk NULL | ridinggloves | standardRidingGloves | RidingSuppInc | WhtBlk 1 NULL i SchwinBike2 BMountain i Schwinn2InMountainbike | Schwinn | 8colors NULL +---- 10 rows in set (0.00 sec) mysql> select * from salesrep; +----- --- Sales RepNum | SalesFName | SalesLName | SalesSSN SalesHDate SalesRate | SalesBonus 1 | 2 | 3 | Mike | Alice | Mary | Smith | Johnson | Halvorson | 222-33-4444 | 999-11-8888 | 333-00-9999 2001-01-01 2004-05-01 1 2004-06-01 251 27 1 221 4000.00 8000.00 NULL 3 rows in set (0.00 sec)