Question: PRODUCT _ CATEGORY product category _ id INTEGER VARCHAR ( 5 0 ) description VARCHAR ( 2 5 5 ) name CUSTOMER customer id INTEGER

PRODUCT_CATEGORY product category_id INTEGER VARCHAR(50) description VARCHAR(255) name CUSTOMER customer id INTEGER firstname VARCHAR(50) lastname VARCHAR(50) register_date DATE birth_date DATE address VARCHAR(255) zipcode CHAR(5) city VARCHAR(50) phone_number VARCHAR(20) PRODUCT product id INTEGER #product_category_id INTEGER name VARCHAR(50) description VARCHAR(255) price DECIMAL(5.2) available_stock INTEGER ORDER_PRODUCT #order id INTEGER #product_id INTEGER PURCHASE_ORDER order id INTEGER #customer_id INTEGER date DATE Modify the query to select only the customers with no associated purchase orders. Only output the CUSTOMER_ID column.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!