SQL> SPOOL currently spooling to ülesanne_12.lst SQL> CREATE TABLE koduylesanded AS (SELECT * FROM scott.koduylesanded); Table created. SQL> COLUMN yliopilase_id FORMAT 999 SQL> COLUMN kursusekood FORMAT A8 SQL> COLUMN too_nr FORMAT 999 SQL> COLUMN yliopilase_id FORMAT 999 SQL> COLUMN punktid FORMAT 999 SQL> COLUMN failinimi FORMAT A8 SQL> SQL> SELECT * FROM koduylesanded; YLIOPILASE_ID KURSUSEK KUUPAEV TOO_NR FAILINIM PUNKTID ------------------------ -------- --------------- ------ -------- ------- 10020014 I319 01-JUN-03 1 t7.txt 10 10020015 I319 11-JUL-03 1 t8.txt 10 10020011 I319 11-JUN-04 2 t2.txt 7 10020013 I319 11-JUN-04 3 t3.txt 8
......................................... ........... select o.nimetus, count(k.too_nr) as toid_kokku from lepikult.koduylesanded k, lepikult.oppeained o where o.kood=k.kursusekood group by o.nimetus; 4............................................................................... ........... select a.naised as naiste_keskmine, b.mehed as meeste_keskmine from ( select round(avg(matemaatika+voorkeel+emakeel),2)/3 as naised from scott.kandidaadid where isikukood like '4%') a, ( select round(avg(matemaatika+voorkeel+emakeel),2)/3 as mehed from scott.kandidaadid where isikukood like '3%') b; 5............................................................................... ........... SELECT a.mehed, a.meeste_aasta, b.naised, b.naiste_aasta FROM ( SELECT round(avg(emakeel),0) as mehed, TO_CHAR(TO_DATE(SUBSTR(isikukood,2,2),'RR'),'rrrr') as meeste_aasta