CREATE TABLE TARI(COD_T NUMBER(3) PRIMARY KEY NOT NULL,DENUMIRE varchar2(25) NOT NULL,CAPITALA varchar2(25) NOT NULL);
CREATE TABLE ORASE(COD_O NUMBER(3) PRIMARY KEY NOT NULL,COD_T NUMBER(3) REFERENCES TARI(COD_T) NOT NULL,NUME_O varchar2(25) NOT NULL,POPULATIE NUMBER(15) NOT NULL);

INSERT INTO TARI VALUES(11,'China','Beijing');
INSERT INTO TARI VALUES(22,'Cehia','Praga');
INSERT INTO TARI VALUES(33,'Egipt','Cairo');
INSERT INTO TARI VALUES(44,'Franta','Paris');
INSERT INTO TARI VALUES(55,'Grecia','Atena');

INSERT INTO ORASE VALUES(1,11,'Tianjin',7200000);
INSERT INTO ORASE VALUES(2,11,'Guangzhou ',11810000);
INSERT INTO ORASE VALUES(3,22,'Ostrava',311402);
INSERT INTO ORASE VALUES(4,22,'Brno',367729);
INSERT INTO ORASE VALUES(5,33,'Beheira',5327000);
INSERT INTO ORASE VALUES(6,33,'Giza',3258540);
INSERT INTO ORASE VALUES(7,44,'Avignon',88312);
INSERT INTO ORASE VALUES(8,44,'Bordeaux',218948);
INSERT INTO ORASE VALUES(9,44,'Lyon',453187);
INSERT INTO ORASE VALUES(10,55,'Salonic',800764);
INSERT INTO ORASE VALUES(11,55,'Tripolis',28928);

SELECT DENUMIRE, NUME_O, POPULATIE
FROM TARI, ORASE O
WHERE TARI.COD_T=O.COD_T AND POPULATIE=(SELECT MAX(POPULATIE) FROM ORASE WHERE COD_T=O.COD_T)
ORDER BY DENUMIRE;

SELECT DENUMIRE, CAPITALA, NUME_O, POPULATIE
FROM TARI,ORASE
WHERE TARI.COD_T=ORASE.COD_T AND (POPULATIE=(SELECT MIN(POPULATIE) FROM TARI,ORASE WHERE TARI.COD_T=ORASE.COD_T) OR POPULATIE=(SELECT MAX(POPULATIE) FROM TARI,ORASE WHERE TARI.COD_T=ORASE.COD_T))
ORDER BY POPULATIE;