Question: PRODUCT _ CATEGORY product category _ id INTEGER VARCHAR ( 5 0 ) description VARCHAR ( 2 5 5 ) name CUSTOMER customer id INTEGER
PRODUCTCATEGORY product categoryid INTEGER VARCHAR description VARCHAR name CUSTOMER customer id INTEGER firstname VARCHAR lastname VARCHAR registerdate DATE birthdate DATE address VARCHAR zipcode CHAR city VARCHAR phonenumber VARCHAR PRODUCT product id INTEGER #productcategoryid INTEGER name VARCHAR description VARCHAR price DECIMAL availablestock INTEGER ORDERPRODUCT #order id INTEGER #productid INTEGER PURCHASEORDER order id INTEGER #customerid INTEGER date DATE Modify the query to select only the customers with no associated purchase orders. Only output the CUSTOMERID column.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
