Delete with correlated EXISTS

Delete with correlated EXISTS

Hard SQL DML 15 views
Explanation Complexity

Problem Statement

Delete orders that have no order items (orphan orders).

Input Format

SQL DML

Output Format

DML statement(s)

Example

Orders, OrderItems
Orphan orders removed

Constraints

None

Input / Output Format

Input Format
SQL DML
Output Format
DML statement(s)
Constraints
None

Examples

Input:
Orders, OrderItems
Output:
Orphan orders removed

Example Solution (Public)

SQL 
DELETE FROM Orders o WHERE NOT EXISTS (SELECT 1 FROM OrderItems oi WHERE oi.order_id = o.order_id);

Official Solution Code

DELETE FROM Orders o WHERE NOT EXISTS (SELECT 1 FROM OrderItems oi WHERE oi.order_id = o.order_id);
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.