Fighting Climate Change

Saving Animal Populations

Create Table SQL

CREATE TABLE tblGoals( 
    pmkMyFavGoals INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fldGoalNumber INT, 
    fldGoalTitle VARCHAR(50), 
    fldSpecificTarget FLOAT 
)

INSERT INTO tblGoals
(pmkGoalNumber, fldGoalTitle, fldSpecificTarget)
VALUES
(2, "Zero Hunger", 2.1),
(11, "Sustainable Cities and Communities", 11.3),
(15, "Life on Land", 15.5),
(6, "Clean Water and Sanitation", 6.4)

SELECT fldGoalNumber, fldGoalTitle, fldSpecificTarget FROM tblGoals