CREATE TABLE table_name_5 (year_8_1st_quad VARCHAR2, year_8_3rd_quad VARCHAR2, year_9_2nd_quad VARCHAR2, year_9_1st_quad VARCHAR2)

For the Crew with Year 9 2nd Quads of STM, Year 9 1st Quads of SOM, and a Year 8 3rd Quads of STA what was the Year 8 1st Quads?
SELECT year_8_1st_quad FROM table_name_5 WHERE year_9_2nd_quad = "stm" AND year_9_1st_quad = "som" AND year_8_3rd_quad = "sta"
SELECT "year_8_1st_quad" FROM "table_name_5" WHERE "som" = "year_9_1st_quad" AND "sta" = "year_8_3rd_quad" AND "stm" = "year_9_2nd_quad"