CREATE TABLE customers_01 (
  customer_id INT PRIMARY KEY,
  first_name VARCHAR(50) NOT NULL,
  last_name VARCHAR(50) NOT NULL,
  phone_no VARCHAR(20),
  city VARCHAR(50) NOT NULL
);

INSERT INTO customers_01 (customer_id, first_name, last_name, phone_no, city)
VALUES (1, 'Amit', 'Kumar', '9876543210', 'Delhi'),
       (2, 'Priya', 'Sharma', '8901234567', 'Mumbai'),
       (3, 'Rahul', 'Singh', '7894561230', 'Bangalore'),
       (4, 'Sita', 'Devi', '6789012345', 'Chennai'),
       (5, 'Mohan', 'Das', '5678901234', 'Kolkata'),
       (6, 'Rani', 'Gupta', '4567890123', 'Hyderabad');

CREATE TABLE orders (
  order_id INT PRIMARY KEY ,
  customer_id INT NOT NULL,
  order_date DATE NOT NULL,
  total_amount INT NOT NULL,
  quantity INT NOT NULL,
  FOREIGN KEY (customer_id) REFERENCES customers_01(customer_id)
);

INSERT INTO orders ( order_id,customer_id, order_date, total_amount, quantity)
VALUES (101,1, '2024-04-03', 150, 3),  
       (102,2, '2024-04-01', 80, 1),  
       (103,4, '2024-03-30', 320, 5),  
       (104,6, '2024-04-02', 60, 2); 
;
select * from customers_01 ;
select * from orders ;
desc orders;


SELECT c.first_name, c.last_name, c.city, o.order_date, o.total_amount, o.quantity
FROM customers_01 AS c
INNER JOIN orders AS o ON c.customer_id = o.customer_id;
 
 
 SELECT c.first_name, c.last_name, c.city, o.order_date, o.total_amount, o.quantity
FROM customers_01 AS c
RIGHT JOIN orders AS o ON c.customer_id = o.customer_id;