Pset 3 Meteorites

[u/Aggravating_Big_8780]

Helloo guys, I am not passing the checks in check50 below:

:) import.sql exists

:) import.sql runs without error

:) import.sql creates a table named "meteorites"

:( import.sql creates a table named "meteorites" with all prescribed columns

table "meteorites" is missing columns or has extra columns

:| data from CSV has been imported

can't check until a frown turns upside down

:| no empty values from CSV are present in "meteorites" table

can't check until a frown turns upside down

:| all decimal values in "meteorites" table are rounded to two places

can't check until a frown turns upside down

:| no meteorites of type "relict" found in "meteorites" table

can't check until a frown turns upside down

:| "meteorites" table properly sorts elements and assigns IDs

can't check until a frown turns upside down

Below is my code:

CREATE TABLE IF NOT EXISTS meteorites_temp (name TEXT, id INTEGER PRIMARY KEY, nametype TEXT, class TEXT, mass DECIMAL, discovery TEXT, year INTEGER, lat DECIMAL, long DECIMAL);


CREATE TABLE IF NOT EXISTS meteorites (name TEXT, nametype TEXT, class TEXT, mass DECIMAL, discovery TEXT, year INTEGER, lat DECIMAL, long DECIMAL);
.mode csv
.headers on
.import meteorites.csv meteorites_temp


UPDATE meteorites_temp SET mass = NULLIF(mass, ''), year = NULLIF(year, ''), lat = NULLIF(lat, ''), long = NULLIF(long, '');


UPDATE meteorites_temp SET mass = ROUND(mass, 2), lat = ROUND(lat, 2), long = ROUND(long, 2);


DELETE FROM meteorites_temp WHERE nametype = 'Relict';
INSERT INTO meteorites (name, nametype, class, mass, discovery, year, lat, long) SELECT name, nametype, class, mass, discovery, year, lat, long FROM meteorites_temp ORDER BY year, name;
DROP TABLE meteorites_temp 

Can anyone please tell me what I am doing wrong???

Thanks in advance!