Nuclear Energy

Create Table SQL

                    CREATE TABLE tblEnergyData(
                        fldSource VARCHAR(45),
                        fldShare FLOAT,
                        fldGainLoss FLOAT,
                        PRIMARY KEY (fldSource)
                    );

                    INSERT INTO tblEnergyData VALUES
                        ('Zero carbon sources', '39.4', '-0.3'),
                        ('Natural gas', '38.3', '-2.3'),
                        ('Coal', '21.8', '2.5'),
                        ('Petroleum sources', '0.5', '0.0');

                    SELECT fldSource, fldShare, fldGainLoss FROM tblEnergyData ORDER BY fldShare DESC;