BILETUL 13

BILETUL 13

bilet13.a1 - create table NAVETA as(select NUME from CLASA13 where upper (DOMICILIU)<>'PUCIOASA');
bilet13.a2 - create table LOCO as(select NUME from CLASA13 where upper (DOMICILIU)='PUCIOASA');
bilet13.b1 - select count(NUME) from NAVETA
bilet13.b2 - select count(NUME) from LOCO
bilet13.c - select DOMICILIU, count(NUME) from CLASA13 where upper (DOMICILIU) <>'PUCIOASA' group by DOMICILIU order by DOMICILIU