SQL Insert Statement With Subquery - MYsql Code

SQL Insert Statement With Subquery – MYsql Code

SQL Insert Statement With Subquery SQL Insert Statement With Subquery - SQL Code -- Create premium_customers table like customers then execute this query INSERT INTO premium_customers SELECT * FROM customers WHERE cust_id IN (SELECT DISTINCT cust_id FROM orders WHERE order_value > 5000); Try Your Self ->

SQL Insert Statement With Subquery – MYsql Code

SQL Insert Statement With Subquery

SQL Insert Statement With Subquery - SQL Code

-- Create premium_customers table like customers then execute this query
INSERT INTO premium_customers
SELECT * FROM customers
WHERE cust_id IN (SELECT DISTINCT cust_id FROM orders WHERE order_value > 5000);