BILETUL 12

BILETUL 12

bilet12.a - select NUME from TARI12 where populatie>200000000;
bilet12.b - select NUME, POPULATIE from TARI12 where upper (CONTINENT) ='EUROPA';
bilet12.c.Asia - select NUME from TARI12 where suprafata = ( select max(suprafata) from TARI12 where upper (CONTINENT)='ASIA');
bilet12.c.Europa - select NUME from TARI12 where suprafata = ( select max(suprafata) from TARI12 where upper (CONTINENT)='EUROPA');
bilet12.c.America de Nord - select NUME from TARI12 where suprafata = ( select max(suprafata) from TARI12 where upper (CONTINENT)='AMERICA DE NORD');
bilet12.c.America de Sud - select NUME from TARI12 where suprafata = ( select max(suprafata) from TARI12 where upper (CONTINENT)='AMERICA DE SUD');