CREATE TABLE region (region_id NUMBER, region_code CLOB, region_name CLOB)
CREATE TABLE storm (storm_id NUMBER, name CLOB, dates_active CLOB, max_speed NUMBER, damage_millions_usd NUMBER, number_deaths NUMBER)
CREATE TABLE affected_region (region_id NUMBER, storm_id NUMBER, number_city_affected NUMBER)

What are the codes and names for all regions, sorted by codes?
SELECT region_code, region_name FROM region ORDER BY region_code
SELECT "region_code", "region_name" FROM "region" ORDER BY "region_code"