Hi I need help with this mysql question:

Display the last name, first name, and email address of the customers who made the purchase with order IDs 1, 2, and 3. Use a subquery. */

Display the last name, first name, and email address of customers who have purchased an item that was supplied by a vendor with a company name that begins with the letter H. Use a subquery. */

For each product that has more than two items sold within all sales transactions, retrieve the product id, product name, and product price. Use a subquery. */

disabled store id store id region_id region_name order id customer id employee_id store_id order_date ship_amount tax_amount ship_date shipping_address_idINT(4) card type card_number card_expires billing_address_id orderid VARCHAR(10) VARCHAR(3) CHAR(5) CHAR(5) CHAR(25) INT(4) INT(4) INT(4) VARCHAR(3) DATETIME DECIMAL(10,2) DECIMAL(10,2) DATETIME STORE PK PK FK FK FK ORDERS CUSTOMER EMPLOYEE STORE VARCHAR(50) CHAR(16) VARCHAR(7) INT(4) INT(4) ORDERITEMS PK ORDERS FK itemid product_id quantit item_price discount amount employee_id store_id first name last name phone email salary mgr INT(4) INT(4) INT(3) DECIMAL(10,2) DECIMAL(10,2) INT(4) VARCHAR(3) CHAR(25) CHAR(25) CHAR(12) VARCHAR(100) DECIMAL(10,2) INT(4) INT VARCHAR(255) CHAR(255) CHAR(255) CHAR(255) FK PRODUCT EMPLOYEE PK FK STORE UNIQUE ADMINISTRATORS admin id PK email_address password first name last_name