Reusable Water Bottles

At a Glance


Create Table SQL

    CREATE TABLE tblPollutionCountry(
        pmkPollutionCountry int NOT NULL AUTO_INCREMENT PRIMARY KEY,
        fldCountry VARCHAR(50) DEFAULT NULL,
        fldAmount VARCHAR(50) DEFAULT NULL,
        fldAmountOcean VARCHAR(50) DEFAULT NULL,
        fldPopulation VARCHAR(50) DEFAULT NULL
    )
    

Insert records into the table labs

    INSERT INTO tblPollutionCountry
    (pmkPollutionCountry, fldCountry, 
    fldAmount, fldAmountOcean, fldPopulation)
    VALUES
    (1, 'China', '8.80m', '3.53m', '1.338b'),
    (2, 'Indonesia', '3.20m', '1.29m', '244m'),
    (3, 'Philippines', '1.90m', '0.75m', '94.64m');