init_db.sql

insert into sector values (1,"Hello", "Communication");
insert into sector values (2,"Hello", "Health");
insert into sector values (3,"Hello", "Entertainment");

insert into exchange values (1,"Mumbai","NSE","");
insert into exchange values (2,"Mumbai","BSE","");
insert into exchange values (3,"Mumbai","NIFTY","");
insert into exchange values (4,"New York","NYSE","");

insert into company values (1000,"A,B", "Rohit" , "Jio", "1 Billion", "", 1);
insert into company values (1001,"A,B", "Rohit" , "Jio", "1 Billion", "", 2);
insert into company values (1002,"A,B", "Rahul" , "Netflix", "1 Billion", "", 3);
insert into company values (1100,"A,B", "Abhishek" , "Reliance", "1 Billion", "", 1);
insert into company values (1003,"A,B", "Rahul" , "Huawei", "1 Billion","", 1);

insert into stock_price values(4,"2014-12-10",43, 03-22-22,1100,1);
insert into stock_price values(3,"2013-12-10",1565, 03-22-22,1001,1);
insert into stock_price values(2,"2014-01-10",90, 03-22-22,1000,1);
insert into stock_price values(1,"2014-04-10",135, 03-22-22,1000,1);

insert into stock_price values (6,'2014-03-10',543,'12:21:21',1003,1);
insert into stock_price values (5,'2014-03-10',543,'12:21:21',1003,1);
insert into stock_price values (5,'2014-03-10',31,'12:21:21',1001,1);

insert into stock_price values (7,'2020-08-22',543,'12:21:21',1003,1);
insert into stock_price values (8,'2020-08-27',343,'12:21:21',1003,1);
insert into stock_price values (9,'2020-08-18',31,'12:21:21',1003,1);
insert into stock_price values (10,'2020-08-30',43,'12:21:21',1003,1);
insert into stock_price values (11,'2020-08-20',33,'12:21:21',1003,1);
insert into stock_price values (12,'2020-08-11',311,'12:21:21',1003,1);