Hi I need help with this question:

USE MYSQL too:

Display the last name and first name of customers who have purchased an item that costs more

than $300 (item_price). Use a subquery.

PK FK TABLE NAME ATTRIBUTE NAME DATA TYPE RANGE OR REFERENCED FK TABLE CUSTOMER customer_id first_name last name email_address shipping_ address_id billing_address_id password product_id category_id product code product_name description list_price discount percent date added vendor id category_id category_name vendor id company_name contact fname contact Iname address city state ZI phone fax email address id customer id ine1 line2 city state zip code phone INT(4) VARCHAR(60) VARCHAR(60) VARCHAR(100) INT(5) INT(5) VARCHAR(60) INT(4) INT(4) VARCHAR(10) VARCHAR(50) TEXT DECIMAL(10,2) DECIMAL(10,2) DATETIME INT(4) INT(4) VARCHAR(50) INT VARCHAR(100) VARCHAR (25) VARCHAR(25) VARCHAR(35) VARCHAR(35) VARCHAR(2) VARCHAR(5) CHAR(12) CHAR(12) VARCHAR(100) VARCHAR(4) VARCHAR(10) VARCHAR(60) VARCHAR(60) VARCHAR(40) VARCHAR(2) VARCHAR(10) VARCHAR(12) PK UNIQUE PRODUCT PK FK CATEGORY UNIQUE NULL FK PK VENDOR CATEGORY UNIQUE VENDOR PK PK FK ADDRESS CUSTOMER