Inner Join Orders

-- Drill 11 — INNER JOIN الطلبات والعملاء — SQLite 3.x+
PRAGMA foreign_keys = ON;

CREATE TABLE customers (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL
);

CREATE TABLE orders (
  id INTEGER PRIMARY KEY,
  customer_id INTEGER NOT NULL REFERENCES customers(id),
  total_halalas INTEGER NOT NULL
);

INSERT INTO customers VALUES (1, 'Sara');
INSERT INTO orders VALUES (10, 1, 5000);

SELECT
  orders.id AS order_id,
  customers.name AS customer_name,
  orders.total_halalas
FROM orders
INNER JOIN customers
  ON customers.id = orders.customer_id;