SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Customers ( id INT PRIMARY KEY, name VARCHAR(20) ); INSERT INTO Customers (id, name) VALUES (101, 'Steven'), (102, 'Laura'), (103, 'Jordan'), (104, 'Thomas'), (105, 'Anne'), (106, 'Robin'), (107, 'Sean'), (108, 'Michael'), (109, 'Raymond'), (110, 'Chad'); CREATE TABLE Sellers ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(20) ); INSERT INTO Sellers (name) VALUES ('Deanna'), ('Danielle'), ('Bonnie'), ('Matthew'), ('Jennifer'), ('John'); CREATE TABLE Orders ( id INT PRIMARY KEY AUTO_INCREMENT, order_cost DECIMAL, customer_id INT, seller_id INT, FOREIGN KEY (customer_id) REFERENCES Customers (id), FOREIGN KEY (seller_id) REFERENCES Sellers (id) ); TRUNCATE Orders; INSERT INTO Orders (order_cost, customer_id, seller_id) VALUES (300, 105, 4), (120, 106, 5), (80, 107, 2), (150, 108, 3), (90, 109, 4), (70, 110, 1), (180, 101, 2); SELECT DISTINCT * FROM Orders RIGHT JOIN Customers ON Orders.customer_id = Customers.id WHERE customer_id NOT IN (SELECT Customers.id FROM Orders RIGHT JOIN Customers ON Orders.customer_id = Customers.id LEFT JOIN Sellers ON Sellers.id = Orders.seller_id AND Sellers.name = 'Bonnie' WHERE Sellers.name = 'Bonnie')