Alternative Energy Options

Create Table SQL

CREATE TABLE tblEnergyOpts(
    pmkOptionId INT AUTO_INCREMENT PRIMARY KEY,
    fldOption VARCHAR(20),
    fldCost FLOAT,
    fldEfficiency VARCHAR(10)
)

INSERT INTO tblEnergyOpts
(fldOption, fldCost, fldEfficiency)
VALUES
('Coal', 4.8, '32%-45%'),
('Hydroelectric', 5.1, "90%-100%"),
('Nuclear', 4.3, '30%-36%')

SELECT fldOption, fldCost, fldEfficiency
FROM tblEnergyOpts