SQL> select NAME from COUNTRY where REGION = 'South America' order by POPULATION; NAME -------------------------------------------------- Falkland Islands (Islas Malvinas) French Guiana Suriname Guyana Uruguay Paraguay Bolivia Ecuador Chile Venezuela Peru NAME -------------------------------------------------- Argentina Colombia Brazil 14 rows selected. SQL> select * from COUNTRY where REGION = 'North America' and POPULATION < 10000000; NAME -------------------------------------------------- REGION AREA ------------------------------------------------------------ ---------- POPULATION GDP ---------- ---------- Saint Pierre and Miquelon North America 242 6757 66000000 Bermuda North America 50 61629 1700000000 NAME -------------------------------------------------- REGION AREA ------------------------------------------------------------ ---------- POPULATION GDP ---------- ---------- SQL> select NAME from COUNTRY where GDP > 5000000000 and GDP < 6000000000 order by AREA desc; NAME -------------------------------------------------- Namibia Gabon Haiti Mali SQL> select distinct REGION from COUNTRY where NAME like '%x%'; REGION ------------------------------------------------------------ Europe North America SQL> select count(distinct NAME ) from COUNTRY where REGION = 'Africa'; COUNT(DISTINCTNAME) ------------------- 59 SQL> select avg( AREA ) from COUNTRY where REGION = 'Central America and the Caribbean'; AVG(AREA) ---------- 23715.25 SQL> select REGION from COUNTRY where POPULATION > 100000000 group by REGION having count(*) > 5; REGION ------------------------------------------------------------ Asia SQL> select REGION from COUNTRY where POPULATION > 0 group by REGION order by sum(GDP)/sum(POPULATION) desc; REGION ------------------------------------------------------------ North America Europe Oceania Arctic Region South America World Middle East Ethnic Groups in Eastern Europe, Europe Southeast Asia Commonwealth of Independent States - European States Asia REGION ------------------------------------------------------------ Central America and the Caribbean Commonwealth of Independent States - Central Asian States Africa 14 rows selected. SQL> insert into COUNTRY values ('CCC',null,9999,1,null); 1 row created. SQL> update COUNTRY set POPULATION = POPULATION + 1000000 where GDP > 10000000000; 109 rows updated. SQL> delete from COUNTRY where REGION is null; 1 row deleted. SQL> spool off