//create a new database for data tables CREATE database ESG_Companies; use database ESG_Companies; //create a table for company facts create or replace TABLE ESG_COMPANIES.PUBLIC.ESG_COMPANY_FACTS ( COMPANYNAME VARCHAR(16777216), SYMBOL VARCHAR(16777216), LOGO VARCHAR(16777216), YEAR_FOUNDED FLOAT, EMPLOYEECOUNT FLOAT, REVENUE_USD FLOAT ); /* INSERT QUERY NO: 1 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Apple Inc.', 'AAPL', 'https://1000logos.net/wp-content/uploads/2016/10/Apple-Logo.png', 1976, 154000, 3.66E+11 ); /* INSERT QUERY NO: 2 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'NVIDIA Corporation', 'NVDA', 'https://www.nvidia.com/content/dam/en-zz/Solutions/about-nvidia/logo-and-brand/01-nvidia-logo-vert-500x200-2c50-d@2x.png', 1993, 22473, 26910000000 ); /* INSERT QUERY NO: 3 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Sony Group Corporation', 'JT:6758', 'https://logos-world.net/wp-content/uploads/2020/04/Sony-Logo-1957-1961.png', 1946, 109700, 81380000000 ); /* INSERT QUERY NO: 4 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'QUALCOMM Incorporated', 'QCOM', 'https://events.nrf.com/annual2022/Custom/BPCompanyLogos/qc_logo_dml_rgb_blu_pos_120348.png', 1985, 45000, 33570000000 ); /* INSERT QUERY NO: 5 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Cisco Systems Inc.', 'CSCO', 'https://upload.wikimedia.org/wikipedia/commons/thumb/0/08/Cisco_logo_blue_2016.svg/1200px-Cisco_logo_blue_2016.svg.png', 1984, 79500, 49810000000 ); /* INSERT QUERY NO: 6 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'SAP SE', 'GF:SAP', 'https://download.logo.wine/logo/SAP_SE/SAP_SE-Logo.wine.png', 1972, 107415, 29420000000 ); /* INSERT QUERY NO: 7 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'ASML Holding N.V.', 'NA:ASML', 'https://upload.wikimedia.org/wikipedia/en/6/6c/ASML_Holding_N.V._logo.svg', 1984, 32016, 19660000000 ); /* INSERT QUERY NO: 8 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Adobe Inc.', 'ADBE', 'https://upload.wikimedia.org/wikipedia/commons/thumb/e/e5/Adobe_Systems_Logo_002.svg/2560px-Adobe_Systems_Logo_002.svg.png', 1982, 25988, 15785000000 ); /* INSERT QUERY NO: 9 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Roche Holding AG', 'RHHVF', 'https://upload.wikimedia.org/wikipedia/commons/thumb/f/f5/Hoffmann-La_Roche_logo.svg/640px-Hoffmann-La_Roche_logo.svg.png', 1896, 100920, 64800000000 ); /* INSERT QUERY NO: 10 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'UnitedHealth Group Incorporated', 'UNH', 'https://seeklogo.com/images/U/unitedhealth-group-logo-F4D2CE10C6-seeklogo.com.png', 1977, 300000, 2.85E+11 ); /* INSERT QUERY NO: 11 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Novo Nordisk A/S', 'DC:NOVO-B', 'https://cdn.freebiesupply.com/logos/large/2x/novo-nordisk-1-logo-png-transparent.png', 1923, 45971, 19980000000 ); /* INSERT QUERY NO: 12 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Mastercard Incorporated', 'MA', 'https://1000logos.net/wp-content/uploads/2017/03/Mastercard-logo.png', 1966, 24000, 18880000000 ); /* INSERT QUERY NO: 13 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Visa Inc.', 'V', 'https://download.logo.wine/logo/Visa_Inc./Visa_Inc.-Logo.wine.png', 1958, 21500, 24110000000 ); /* INSERT QUERY NO: 14 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'AstraZeneca PLC', 'LN:AZN', 'https://www.logo.wine/a/logo/AstraZeneca/AstraZeneca-Logo.wine.svg', 1999, 76100, 37417000000 ); /* INSERT QUERY NO: 15 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Toyota Motor Corporation', 'JT:7203', 'https://www.pngall.com/wp-content/uploads/2016/04/Toyota-Logo-Free-Download-PNG.png', 1937, 366283, 2.57E+11 ); /* INSERT QUERY NO: 16 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Bristol-Myers Squibb Company', 'BMY', 'https://upload.wikimedia.org/wikipedia/commons/c/c6/Bristol-Myers_Squibb_logo_%282020%29.svg', 1887, 30000, 42518000000 ); /* INSERT QUERY NO: 17 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Novartis AG', 'NVSEF', 'https://cdn.freebiesupply.com/logos/large/2x/novartis-1-logo-png-transparent.png', 1996, 110000, 51600000000 ); /* INSERT QUERY NO: 18 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Accenture plc', 'ACN', 'https://upload.wikimedia.org/wikipedia/commons/thumb/c/cd/Accenture.svg/2560px-Accenture.svg.png', 1989, 699000, 50530000000 ); /* INSERT QUERY NO: 19 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Costco Wholesale Corporation', 'COST', 'https://1000logos.net/wp-content/uploads/2021/04/Costco-logo.png', 1983, 273000, 1.67E+11 ); /* INSERT QUERY NO: 20 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'L\'Oreal S.A.', 'FP:OR', 'https://logos-download.com/wp-content/uploads/2016/02/Loreal_logo.png', 1909, 88000, 32280000000 ); /* INSERT QUERY NO: 21 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Walmart Inc.', 'WMT', 'https://logos-download.com/wp-content/uploads/2016/02/Walmart_logo_transparent_png.png', 1962, 2300000, 5.73E+11 ); /* INSERT QUERY NO: 22 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'LVMH Moët Hennessy - Louis Vuitton Société Européenne', 'FP:MC', 'https://1000logos.net/wp-content/uploads/2021/04/Louis-Vuitton-logo.png', 1854, 1900, 14700000000 ); /* INSERT QUERY NO: 23 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Merck & Co. Inc.', 'MRK', 'https://upload.wikimedia.org/wikipedia/commons/thumb/9/94/Merck_Logo.svg/2560px-Merck_Logo.svg.png', 1891, 74000, 47994000000 ); /* INSERT QUERY NO: 24 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Deere & Company', 'DE', 'https://upload.wikimedia.org/wikipedia/en/thumb/c/cf/John_Deere_logo.svg/1200px-John_Deere_logo.svg.png', 1837, 69600, 39540000000 ); /* INSERT QUERY NO: 25 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Intel Corporation', 'INTC', 'https://www.intel.com/etc.clientlibs/settings/wcm/designs/intel/us/en/images/resources/printlogo.png', 1968, 121100, 79020000000 ); /* INSERT QUERY NO: 26 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Tencent Holdings Limited', 'HK:0700', 'https://cdn.freelogovectors.net/wp-content/uploads/2018/08/tencent-logo.png', 1998, 112771, 84529000000 ); /* INSERT QUERY NO: 27 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Alibaba Group Holding Limited', 'BABA', 'https://upload.wikimedia.org/wikipedia/en/thumb/8/80/Alibaba-Group-Logo.svg/220px-Alibaba-Group-Logo.svg.png', 1999, 251462, 1.09E+11 ); /* INSERT QUERY NO: 28 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Johnson & Johnson', 'JNJ', 'https://upload.wikimedia.org/wikipedia/commons/thumb/c/cd/Johnson_and_Johnson_Logo.svg/2560px-Johnson_and_Johnson_Logo.svg.png', 1886, 144500, 93770000000 ); /* INSERT QUERY NO: 29 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Alphabet Inc.', 'GOOGL', 'https://upload.wikimedia.org/wikipedia/commons/thumb/7/7a/Alphabet_Inc_Logo_2015.svg/220px-Alphabet_Inc_Logo_2015.svg.png', 2015, 156500, 2.58E+11 ); /* INSERT QUERY NO: 30 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Medtronic plc', 'MDT', 'https://upload.wikimedia.org/wikipedia/commons/thumb/2/2c/Medtronic_logo.svg/220px-Medtronic_logo.svg.png', 1949, 90000, 30117000000 ); /* INSERT QUERY NO: 31 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'T-Mobile US Inc.', 'TMUS', 'https://upload.wikimedia.org/wikipedia/commons/thumb/8/88/T-Mobile_US_Logo_2022_RGB_Magenta_on_Transparent.svg/200px-T-Mobile_US_Logo_2022_RGB_Magenta_on_Transparent.svg.png', 1994, 75000, 68397000000 ); /* INSERT QUERY NO: 32 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'The Charles Schwab Corporation', 'SCHW', 'https://upload.wikimedia.org/wikipedia/commons/thumb/4/4b/Charles_Schwab_Corporation_logo.svg/110px-Charles_Schwab_Corporation_logo.svg.png', 1971, 33400, 18520000000 ); /* INSERT QUERY NO: 33 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Salesforce Inc.', 'CRM', 'https://upload.wikimedia.org/wikipedia/commons/thumb/f/f9/Salesforce.com_logo.svg/220px-Salesforce.com_logo.svg.png', 1999, 56600, 21250000000 ); /* INSERT QUERY NO: 34 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'NIKE Inc.', 'NKE', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/a6/Logo_NIKE.svg/200px-Logo_NIKE.svg.png', 1964, 75400, 37400000000 ); /* INSERT QUERY NO: 35 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Verizon Communications Inc.', 'VZ', 'https://upload.wikimedia.org/wikipedia/commons/thumb/8/81/Verizon_2015_logo_-vector.svg/220px-Verizon_2015_logo_-vector.svg.png', 1983, 118400, 1.34E+11 ); /* INSERT QUERY NO: 36 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'McDonald\'s Corporation', 'MCD', 'https://upload.wikimedia.org/wikipedia/commons/thumb/3/36/McDonald%27s_Golden_Arches.svg/langfr-300px-McDonald%27s_Golden_Arches.svg.png', 1940, 1700000, 21076000000 ); /* INSERT QUERY NO: 37 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Meta Platforms Inc.', 'FB', 'https://upload.wikimedia.org/wikipedia/commons/thumb/7/7b/Meta_Platforms_Inc._logo.svg/440px-Meta_Platforms_Inc._logo.svg.png', 2004, 77805, 1.18E+11 ); /* INSERT QUERY NO: 38 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Lowe\'s Companies Inc.', 'LOW', 'https://upload.wikimedia.org/wikipedia/commons/thumb/2/2c/Lowes_Companies_Logo.svg/1200px-Lowes_Companies_Logo.svg.png', 1946, 300000, 72148000000 ); /* INSERT QUERY NO: 39 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Pfizer Inc.', 'PFE', 'https://upload.wikimedia.org/wikipedia/commons/thumb/e/e3/Pfizer.svg/1200px-Pfizer.svg.png', 1849, 79000, 61280000000 ); /* INSERT QUERY NO: 40 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Sanofi', 'FP:SAN', 'https://upload.wikimedia.org/wikipedia/commons/thumb/f/f5/Sanofi-2022.svg/440px-Sanofi-2022.svg.png', 1973, 99412, 36120000000 ); /* INSERT QUERY NO: 41 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'The Home Depot Inc.', 'HD', 'https://upload.wikimedia.org/wikipedia/commons/thumb/5/5f/TheHomeDepot.svg/360px-TheHomeDepot.svg.png', 1978, 490600, 1.51E+11 ); /* INSERT QUERY NO: 42 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Raytheon Technologies Corporation', 'RTX', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/a8/Raytheon_Technologies_logo.svg/440px-Raytheon_Technologies_logo.svg.png', 2020, 174000, 64390000000 ); /* INSERT QUERY NO: 43 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Eli Lilly and Company', 'LLY', 'https://upload.wikimedia.org/wikipedia/commons/thumb/2/2b/Eli_Lilly_and_Company.svg/440px-Eli_Lilly_and_Company.svg.png', 1876, 33625, 22319000000 ); /* INSERT QUERY NO: 44 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Intuit Inc.', 'INTU', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/ae/Intuit_Logo.svg/460px-Intuit_Logo.svg.png', 1983, 14200, 9633000000 ); /* INSERT QUERY NO: 45 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Wuliangye Yibin Co.Ltd.', 'CS:000858', 'https://banner2.cleanpng.com/20180806/kec/kisspng-baijiu-wuliangye-yibin-business-alcoholic-drink-si-%E4%BC%97%E8%AA%89%E4%BC%81%E4%B8%9A19-%E4%BA%94%E7%B2%AE%E6%B6%B2%E9%9B%86%E5%9B%A2%E6%9C%89%E9%99%90%E5%85%AC%E5%8F%B8_%E6%97%B6%E5%B0%9A-5b686a13bc5125.0625228715335695557714.jpg', 1998, 25882, 8674000000 ); /* INSERT QUERY NO: 46 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'The Procter & Gamble Company', 'PG', 'https://upload.wikimedia.org/wikipedia/commons/thumb/8/85/Procter_%26_Gamble_logo.svg/300px-Procter_%26_Gamble_logo.svg.png', 1837, 101000, 14310000000 ); /* INSERT QUERY NO: 47 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Taiwan Semiconductor Manufacturing Company Limited', 'TT:2330', 'https://upload.wikimedia.org/wikipedia/en/thumb/6/63/Tsmc.svg/400px-Tsmc.svg.png', 1987, 56831, 47950000000 ); /* INSERT QUERY NO: 48 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'China Mobile Limited', 'HK:0941', 'https://upload.wikimedia.org/wikipedia/en/thumb/9/90/China_Mobile_logo_%282019%29.svg/440px-China_Mobile_logo_%282019%29.svg.png', 1997, 456239, 1.08E+11 ); /* INSERT QUERY NO: 49 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'AbbVie Inc.', 'ABBV', 'https://upload.wikimedia.org/wikipedia/commons/thumb/c/cc/AbbVie_logo.svg/440px-AbbVie_logo.svg.png', 2013, 50000, 56200000000 ); /* INSERT QUERY NO: 50 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Philip Morris International Inc.', 'PM', 'https://upload.wikimedia.org/wikipedia/en/thumb/5/55/Philip_Morris_International.svg/498px-Philip_Morris_International.svg.png', 1847, 71000, 76047000000 ); /* INSERT QUERY NO: 51 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Hermès International S.A.', 'FP:RMS', 'https://upload.wikimedia.org/wikipedia/en/thumb/e/e4/Herm%C3%A8s.svg/400px-Herm%C3%A8s.svg.png', 1837, 17595, 8982000000 ); /* INSERT QUERY NO: 52 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Advanced Micro Devices Inc.', 'AMD', 'https://upload.wikimedia.org/wikipedia/commons/thumb/7/7c/AMD_Logo.svg/440px-AMD_Logo.svg.png', 1969, 15500, 16400000000 ); /* INSERT QUERY NO: 53 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Thermo Fisher Scientific Inc.', 'TMO', 'https://upload.wikimedia.org/wikipedia/commons/thumb/5/50/Thermo_Fisher_Scientific_logo.svg/400px-Thermo_Fisher_Scientific_logo.svg.png', 1956, 125000, 32210000000 ); /* INSERT QUERY NO: 54 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Danaher Corporation', 'DHR', 'https://upload.wikimedia.org/wikipedia/commons/thumb/d/d8/Danaher_Corporation_logo.svg/440px-Danaher_Corporation_logo.svg.png', 1969, 80000, 29453000000 ); /* INSERT QUERY NO: 55 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Amgen Inc.', 'AMGN', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/ab/Amgen.svg/500px-Amgen.svg.png', 1980, 22000, 25424000000 ); /* INSERT QUERY NO: 56 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Morgan Stanley', 'MS', 'https://upload.wikimedia.org/wikipedia/commons/thumb/7/7e/Morgan_Stanley_Logo.svg/440px-Morgan_Stanley_Logo.svg.png', 1935, 75000, 59800000000 ); /* INSERT QUERY NO: 57 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Amazon.com Inc.', 'AMZN', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/a9/Amazon_logo.svg/350px-Amazon_logo.svg.png', 1994, 1608000, 4.70E+11 ); /* INSERT QUERY NO: 58 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'The Toronto-Dominion Bank', 'CT:TD', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/a4/Toronto-Dominion_Bank_logo.svg/250px-Toronto-Dominion_Bank_logo.svg.png', 1955, 89464, 42690000000 ); /* INSERT QUERY NO: 59 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'China Construction Bank Corporation', 'HK:0939', 'https://upload.wikimedia.org/wikipedia/en/thumb/e/e8/China_Construction_Bank.svg/500px-China_Construction_Bank.svg.png', 1954, 345971, 1.75E+11 ); /* INSERT QUERY NO: 60 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'American Express Company', 'AXP', 'https://upload.wikimedia.org/wikipedia/commons/thumb/f/fa/American_Express_logo_%282018%29.svg/300px-American_Express_logo_%282018%29.svg.png', 1850, 63700, 43660000000 ); /* INSERT QUERY NO: 61 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Kweichow Moutai Co. Ltd.', 'CG:600519', 'https://upload.wikimedia.org/wikipedia/en/thumb/6/69/Kweichow_Moutai_Logo.png/220px-Kweichow_Moutai_Logo.png', 1999, 30000, 16070000000 ); /* INSERT QUERY NO: 62 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'The Coca-Cola Company', 'KO', 'https://upload.wikimedia.org/wikipedia/commons/thumb/0/09/The_Coca-Cola_Company_%282020%29.svg/440px-The_Coca-Cola_Company_%282020%29.svg.png', 1892, 86200, 37270000000 ); /* INSERT QUERY NO: 63 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Nestlé S.A.', 'NSRGF', 'https://upload.wikimedia.org/wikipedia/en/thumb/d/d8/Nestl%C3%A9.svg/440px-Nestl%C3%A9.svg.png', 1866, 276000, 89480000000 ); /* INSERT QUERY NO: 64 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Royal Bank of Canada', 'CT:RY', 'https://upload.wikimedia.org/wikipedia/en/thumb/7/7f/RBC_Royal_Bank.svg/200px-RBC_Royal_Bank.svg.png', 1864, 85301, 38610000000 ); /* INSERT QUERY NO: 65 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'United Parcel Service Inc.', 'UPS', 'https://upload.wikimedia.org/wikipedia/commons/thumb/6/6b/United_Parcel_Service_logo_2014.svg/350px-United_Parcel_Service_logo_2014.svg.png', 1907, 534000, 84628000000 ); /* INSERT QUERY NO: 66 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Agricultural Bank of China Limited', 'HK:1288', 'https://upload.wikimedia.org/wikipedia/en/thumb/6/69/Agricultural_Bank_of_China_logo.svg/600px-Agricultural_Bank_of_China_logo.svg.png', 1951, 467631, 1.54E+11 ); /* INSERT QUERY NO: 67 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Bank of China Limited', 'HK:3988', 'https://upload.wikimedia.org/wikipedia/en/thumb/7/72/Bank_of_China.svg/500px-Bank_of_China.svg.png', 1912, 311000, 73230000000 ); /* INSERT QUERY NO: 68 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'HSBC Holdings plc', 'HK:0005', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/aa/HSBC_logo_%282018%29.svg/440px-HSBC_logo_%282018%29.svg.png', 1865, 219697, 49552000000 ); /* INSERT QUERY NO: 69 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Linde plc', 'LIN', 'https://upload.wikimedia.org/wikipedia/commons/thumb/6/6f/Linde_plc_logo.png/440px-Linde_plc_logo.png', 1879, 74207, 27243000000 ); /* INSERT QUERY NO: 70 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Contemporary Amperex Technology Co. Limited', 'CS:300750', 'https://upload.wikimedia.org/wikipedia/commons/thumb/0/0d/Contemporary_Amperex_Technology_logo.svg/440px-Contemporary_Amperex_Technology_logo.svg.png', 2011, 83601, 7650000000 ); /* INSERT QUERY NO: 71 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Comcast Corporation', 'CMCSA', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/a3/Comcast_Logo.svg/220px-Comcast_Logo.svg.png', 1963, 189000, 1.16E+11 ); /* INSERT QUERY NO: 72 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'TotalEnergies SE', 'FP:FP', 'https://upload.wikimedia.org/wikipedia/en/thumb/5/54/TotalEnergies_logo.svg/220px-TotalEnergies_logo.svg.png', 1924, 105476, 1.85E+11 ); /* INSERT QUERY NO: 73 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'NextEra Energy Inc.', 'NEE', 'https://upload.wikimedia.org/wikipedia/commons/thumb/e/e0/NextEra_Energy_logo_%281%29.svg/220px-NextEra_Energy_logo_%281%29.svg.png', 1984, 14800, 19200000000 ); /* INSERT QUERY NO: 74 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Microsoft Corporation', 'MSFT', 'https://upload.wikimedia.org/wikipedia/commons/thumb/9/96/Microsoft_logo_%282012%29.svg/250px-Microsoft_logo_%282012%29.svg.png', 1975, 182268, 1.61E+11 ); /* INSERT QUERY NO: 75 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Samsung Electronics Co. Ltd.', 'KP:005930', 'https://upload.wikimedia.org/wikipedia/commons/thumb/b/b4/Samsung_wordmark.svg/220px-Samsung_wordmark.svg.png', 1969, 287439, 2.20E+11 ); /* INSERT QUERY NO: 76 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Abbott Laboratories', 'ABT', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/a4/Abbott_Laboratories_logo.svg/220px-Abbott_Laboratories_logo.svg.png', 1888, 109000, 34608000000 ); /* INSERT QUERY NO: 77 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Oracle Corporation', 'ORCL', 'https://upload.wikimedia.org/wikipedia/commons/thumb/5/50/Oracle_logo.svg/220px-Oracle_logo.svg.png', 1977, 132000, 40470000000 ); /* INSERT QUERY NO: 78 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Tata Consultancy Services Limited', 'IB:TCS', 'https://upload.wikimedia.org/wikipedia/en/thumb/a/a3/TCS_Official_Logo.svg/250px-TCS_Official_Logo.svg.png', 1968, 528748, 25000000000 ); /* INSERT QUERY NO: 79 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Shell plc', 'LN:RDSA', 'https://upload.wikimedia.org/wikipedia/en/thumb/e/e8/Shell_logo.svg/150px-Shell_logo.svg.png', 1907, 86000, 2.62E+11 ); /* INSERT QUERY NO: 80 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Ping An Insurance (Group) Company of China Ltd.', 'HK:2318', 'https://upload.wikimedia.org/wikipedia/en/thumb/3/3d/Ping_An_Insurance_logo.svg/200px-Ping_An_Insurance_logo.svg.png', 1988, 662035, 1.95E+11 ); /* INSERT QUERY NO: 81 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'JPMorgan Chase & Co.', 'JPM', 'https://upload.wikimedia.org/wikipedia/commons/thumb/0/07/J_P_Morgan_Chase_Logo_2008_1.svg/250px-J_P_Morgan_Chase_Logo_2008_1.svg.png', 2000, 271025, 1.22E+11 ); /* INSERT QUERY NO: 82 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Texas Instruments Incorporated', 'TXN', 'https://upload.wikimedia.org/wikipedia/commons/thumb/b/ba/TexasInstruments-Logo.svg/440px-TexasInstruments-Logo.svg.png', 1930, 31000, 18340000000 ); /* INSERT QUERY NO: 83 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Public Joint Stock Company Mining and Metallurgical Company Norilsk Nickel', 'LI:MNOD', 'https://upload.wikimedia.org/wikipedia/en/3/34/Ural_Mining_and_Metallurgical_Company_logo.png', 1999, 72105, 5100000000 ); /* INSERT QUERY NO: 84 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Chevron Corporation', 'CVX', 'https://upload.wikimedia.org/wikipedia/commons/thumb/8/86/Chevron_Logo.svg/240px-Chevron_Logo.svg.png', 1879, 42595, 1.62E+11 ); /* INSERT QUERY NO: 85 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Tesla Inc.', 'TSLA', 'https://upload.wikimedia.org/wikipedia/commons/thumb/b/bd/Tesla_Motors.svg/240px-Tesla_Motors.svg.png', 2003, 110000, 53800000000 ); /* INSERT QUERY NO: 86 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Industrial & Commercial Bank of China Ltd.', 'HK:1398', 'https://upload.wikimedia.org/wikipedia/en/thumb/3/33/Industrial_and_Commercial_Bank_of_China_logo.svg/500px-Industrial_and_Commercial_Bank_of_China_logo.svg.png', 1984, 453048, 1.05E+11 ); /* INSERT QUERY NO: 87 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Netflix Inc.', 'NFLX', 'https://upload.wikimedia.org/wikipedia/commons/thumb/0/08/Netflix_2015_logo.svg/340px-Netflix_2015_logo.svg.png', 1997, 12135, 29700000000 ); /* INSERT QUERY NO: 88 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'The Walt Disney Company', 'DIS', 'https://upload.wikimedia.org/wikipedia/commons/thumb/4/44/The_Walt_Disney_Company_Logo.svg/440px-The_Walt_Disney_Company_Logo.svg.png', 1923, 190000, 67418000000 ); /* INSERT QUERY NO: 89 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'BHP Group Limited', 'AT:BHP', 'https://upload.wikimedia.org/wikipedia/commons/thumb/b/b6/BHP_2017_logo.svg/440px-BHP_2017_logo.svg.png', 1885, 80000, 60817000000 ); /* INSERT QUERY NO: 90 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'S&P Global Inc.', 'SPGI', 'https://upload.wikimedia.org/wikipedia/commons/thumb/e/ee/S%26P_Global_logo.svg/440px-S%26P_Global_logo.svg.png', 1917, 35000, 8297000000 ); /* INSERT QUERY NO: 91 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'PetroChina Company Limited', 'HK:0857', 'https://upload.wikimedia.org/wikipedia/en/thumb/2/2b/Petrochina_logo.svg/200px-Petrochina_logo.svg.png', 1999, 506000, 2.97E+11 ); /* INSERT QUERY NO: 92 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'PepsiCo Inc.', 'PEP', 'https://upload.wikimedia.org/wikipedia/commons/thumb/a/a6/PepsiCo_logo.svg/500px-PepsiCo_logo.svg.png', 1898, 267000, 70370000000 ); /* INSERT QUERY NO: 93 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Exxon Mobil Corporation', 'XOM', 'https://upload.wikimedia.org/wikipedia/commons/thumb/1/18/Exxon_Mobil_Logo.svg/400px-Exxon_Mobil_Logo.svg.png', 1999, 64000, 2.77E+11 ); /* INSERT QUERY NO: 94 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Union Pacific Corporation', 'UNP', 'https://upload.wikimedia.org/wikipedia/commons/thumb/d/de/Union_pacific_railroad_logo.svg/300px-Union_pacific_railroad_logo.svg.png', 1969, 30960, 19500000000 ); /* INSERT QUERY NO: 95 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Saudi Arabian Oil Company', 'AB:2222', 'https://upload.wikimedia.org/wikipedia/en/thumb/a/a7/Saudi_Aramco_logo.svg/400px-Saudi_Aramco_logo.svg.png', 1933, 66800, 6.22E+11 ); /* INSERT QUERY NO: 96 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Wells Fargo & Company', 'WFC', 'https://upload.wikimedia.org/wikipedia/commons/thumb/e/e2/Wells_Fargo_Logo_%282020%29.svg/400px-Wells_Fargo_Logo_%282020%29.svg.png', 1929, 268531, 78492000000 ); /* INSERT QUERY NO: 97 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Reliance Industries Limited', 'IS:RELIANCE', 'https://upload.wikimedia.org/wikipedia/en/thumb/9/99/Reliance_Industries_Logo.svg/440px-Reliance_Industries_Logo.svg.png', 1973, 236560, 63000000 ); /* INSERT QUERY NO: 98 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'China Merchants Bank Co. Ltd.', 'CG:600036', 'https://upload.wikimedia.org/wikipedia/en/d/d2/Chinamerchants.png', 1991, 9149, 7955100000 ); /* INSERT QUERY NO: 99 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Berkshire Hathaway Inc.', 'BRK.A', 'https://upload.wikimedia.org/wikipedia/commons/thumb/2/23/Berkshire_Hathaway.svg/500px-Berkshire_Hathaway.svg.png', 1839, 372000, 2.76E+11 ); /* INSERT QUERY NO: 100 */ INSERT INTO ESG_COMPANY_FACTS(CompanyName, Symbol, Logo, Year_Founded, EmployeeCount, Revenue_USD) VALUES ( 'Bank of America Corporation', 'BAC', 'https://upload.wikimedia.org/wikipedia/commons/thumb/2/20/Bank_of_America_logo.svg/500px-Bank_of_America_logo.svg.png', 1784, 200000, 89110000000 ); //copy the gaialens ESG scores data into the same database as the company fact table for use in Astrato //copy the gaialens ESG scores data into the same database as the company fact table for use in Astrato create table SCORES_ESG_SAMPLE_TABLE as select * from GAIALENS_SNOWFLAKE_SECURE_SHARE_1650047420321.SCORES.SCORES_E_PILLAR_SAMPLE; //end //end