CREATE table users(
    u_id int,
    name varchar(25),
    address varchar(25),
    PRIMARY KEY (u_id)
    );
    
    create table products(
        p_id int,
        name varchar,(25)
        price int,
        PRIMARY KEY (p_id)
        );
        
     CREATE TABLE orders (
           o_id int,
           u_id int,
           p_id int,
           PRIMARY KEY (o_id),
           FOREIGN KEY (u_id)REFERENCES users (u_id) on  DELETE CASCADE,
           FOREIGN KEY (p_id) REFERENCES products (p_id) on  DELETE CASCADE

           ) ;






INSERT INTO users (u_id,name,address)
VALUES (1,'tariful','rup'),
(2,'B','Ab'),
(3,'C','Ac'),
(4,'D','Abc'),
 (5,'E','Abc'),
 (6,'F','AA'),
 (7,'G','AB'),
 (8,'H','Abc'),
 (9,'I','AD'),
 (10,'J','Ab');

INSERT INTO products (p_id,name,price)
VALUES (11,'tariful','rup'),
(12,'Ba',200),
(13,'Cs',300),
(14,'Dd',400),
 (15,'Eg',500),
 (16,'Fh',600),
 (17,'Gdf',120),
 (18,'Hsd',234),
 (19,'Isdf',105),
 (20,'Jg',220);

INSERT INTO orders (o_id,u_id,p_id)
VALUES (201,1,11),
(202,2,12),
(203,3,13),
(204,4,14),
 (205,5,15),
 (206,6,16),
 (207,7,17),
 (208,8,18),
 (209,9,19),
 (210,10,20),
 (411,6,16),
 (512,7,17),
 (413,4,16),
 (514,5,15),
 (653,9,14);