CREATE TABLE party_host (Party_ID NUMBER, Host_ID NUMBER, Is_Main_in_Charge BOOLEAN)
CREATE TABLE party (Party_ID NUMBER, Party_Theme CLOB, Location CLOB, First_year CLOB, Last_year CLOB, Number_of_hosts NUMBER)
CREATE TABLE host (Host_ID NUMBER, Name CLOB, Nationality CLOB, Age CLOB)

Count the last year of parties with theme 'Spring' or 'Teqnology' with a bar grpah, and I want to show in ascending by the the number of last year.
SELECT Last_year, COUNT(Last_year) FROM party WHERE Party_Theme = "Spring" OR Party_Theme = "Teqnology" GROUP BY Last_year ORDER BY COUNT(Last_year)
SELECT "Last_year", COUNT("Last_year") FROM "party" WHERE "Party_Theme" = "Spring" OR "Party_Theme" = "Teqnology" GROUP BY "Last_year" ORDER BY COUNT("Last_year")