Which sales representative took the order placed in January 2022 by the customer, Mary Hall, living in Austin, TX?  List the name of the sales representative.  

Which product did the customer (who was referred by John Bell) buy?  List the ID number, category of the product and the customer name.

 

CUSTOMER PK CustID 1 SALESREP PK SalesID 105 ORDER PK OrderID 112961 OFFICE PK OfficeID 22 OrderID 112961 PRODUCT PK CustName Lee Smith ORDERLINE PK (OrderID + ProdID) ProdID A1 ProdID A1 Sales Name OfficeID Bill Jones 13 Order Date 2023-4-17 Region Midwest City Lincoln .... City Denver Category Color A 2 State NE White S HireDate 2009-01-11 OtvOrdered CreditLimit 30000 State CO Quota 350000 Size RetailPrice Cost 10 7 ReferredBy ShipDate CustID SalesID 2023-4-17 106 4 Sales 367910 VendorID V374 OtvOnHand 53