.dsy:it. - Interrogazioni SQL esame Gennaio 2009

.dsy:it.
//www.dsy.it

Interrogazioni SQL esame Gennaio 2009

Posted by Sirox on 22-01-2009 16:07

es 1

Select aula,orai from orarilez

where codc in

((Select codc from corsi join corsilaurea using (codl) join turni using (codc)
where anno=2 and facolta='informatica' and semestre=1 and turno=1)

intersect

(Select codc from corsi join corsilaurea using (codl) join turni using (codc)
where anno=2 and facolta='informatica' and semestre=1 and turno=2))
-------------------------------------------------------------------------------------
es 2

Select codd,count(*) from orarilez

where exists
(Select o2.codc from orarilez o2, orarilez o1 where o2.turno<>o1.turno and o1.codc=o2.codc and o1.codd=o2.codd)

group by codd

having count(distinct(codd))>=3
---------------------------------------------------------------------------------------
es 3

select uno.cods,uno.codl,(count(distinct(uno.codc)))/3*2

from (turni join corsi using (codc) join corsilaurea using (codl) join studenti using (codl)) uno

group by uno.codl,uno.cods

having (count(distinct(uno.codc)))/3*2

=

(Select ((count(distinct(codc))))

from (esitiesami join corsi using (codc)) due

where due.voto>=18 and uno.codl=due.codl and uno.cods=due.cods)
---------------------------------------------------------------------------------------

BY Jackmurnau & Sirox

Pensiamo siano giuste!! cmq domani andiamo dal prof!!
Buon divertimento! ;-))))))))))))))