CREATE TABLE finrev_fed_17 (state_code NUMBER, idcensus NUMBER, school_district CLOB, nces_id CLOB, yr_data NUMBER, t_fed_rev NUMBER, c14 NUMBER, c25 NUMBER)
CREATE TABLE finrev_fed_key_17 (state_code NUMBER, state CLOB)
CREATE TABLE ndecoreexcel_math_grade8 (year NUMBER, state CLOB, all_students CLOB, average_scale_score NUMBER)

What are the student scores on the NAEP math exam for 8th graders in North Carolina and South Carolina?
SELECT average_scale_score FROM ndecoreexcel_math_grade8 WHERE state = "North Carolina" UNION SELECT average_scale_score FROM ndecoreexcel_math_grade8 WHERE state = "South Carolina"
SELECT "average_scale_score" FROM "ndecoreexcel_math_grade8" WHERE "North Carolina" = "state" UNION SELECT "average_scale_score" FROM "ndecoreexcel_math_grade8" WHERE "South Carolina" = "state"