SELECT location_name, address FROM Store;
INSERT INTO Customer (first_name, last_name, email, phone_number) VALUES ('John', 'Doe', 'john.doe@gmail.com', '0123456789');
INSERT INTO Product (name, description) VALUES ('USB-C to HDMI Adapter', 'Adapter to connect USB-C devices to a TV or monitor');
SELECT Store.location_name, Inventory.quantity FROM ((Inventory INNER JOIN Product ON Inventory.product_id=Product.id) INNER JOIN Store ON Inventory.store_id=Store.id) WHERE Product.id=1;
SELECT Employee.first_name, Employee.last_name, Store.location_name, Store.address FROM Employee INNER JOIN Store ON Employee.store_id = Store.id;
SELECT * FROM Employee WHERE salary>=100000;
INSERT INTO Sale (store_id, customer_id, employee_id) VALUES (1, 18, 1);
INSERT INTO SaleProduct (product_id, sale_id, quantity) VALUES (1, 1, 1), (2, 1, 3);
SELECT Product.name, Product.description, SaleProduct.quantity FROM SaleProduct INNER JOIN Product ON SaleProduct.product_id=Product.id WHERE SaleProduct.sale_id=1;
SELECT Store.location_name AS store_name, Employee.first_name AS employee_first_name, Employee.last_name AS employee_last_name, Customer.first_name AS customer_first_name, Customer.last_name AS customer_last_name FROM (((Sale INNER JOIN Store ON Sale.store_id=Store.id) INNER JOIN Employee ON Sale.employee_id=Employee.id) INNER JOIN Customer ON Sale.customer_id=Customer.id) WHERE Sale.id=1;