Week2Test/CreateTable_Dividend.sql at main · Adarsh-D23/Week2Test · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
CREATE TABLE dividend
(
 company character varying(12),
 fiscal_year integer
 );

INSERT INTO dividend(company,fiscal_year) VALUES('AHPC',20702071);
INSERT INTO dividend(company,fiscal_year) VALUES('AHPC',20712072);
INSERT INTO dividend(company,fiscal_year) VALUES('AHPC',20732074);
INSERT INTO dividend(company,fiscal_year) VALUES('AHPC',20762077);
INSERT INTO dividend(company,fiscal_year) VALUES('CZBIL',20692070);
INSERT INTO dividend(company,fiscal_year) VALUES('CZBIL',20702071);
INSERT INTO dividend(company,fiscal_year) VALUES('CZBIL',20712072);
INSERT INTO dividend(company,fiscal_year) VALUES('CZBIL',20732074);
INSERT INTO dividend(company,fiscal_year) VALUES('GBIME',20692070);
INSERT INTO dividend(company,fiscal_year) VALUES('GBIME',20702071);
INSERT INTO dividend(company,fiscal_year) VALUES('GBIME',20712072);
INSERT INTO dividend(company,fiscal_year) VALUES('GBIME',20732074);