Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select*
- from hallgatok
- where telepules='Tata'
- select*
- from jegyek
- where vdatum='2007.01.10'
- select count(*)
- from hallgatok
- select count(*) as 'Hallgatók száma'
- from hallgatok
- select tkov, count(tkov)
- from tantargyak
- group by tkov
- select*
- from hallgatok
- select*
- from hallgatok
- where nev like'%Péter%'
- select count(uv) as 'uv-s hallgatók száma'
- from jegyek
- where uv !=0
- select case kforma
- when 1 then 'BSC'
- when 2 then 'MSC'
- when 3 then 'PHD'
- else 'kodhiba'
- end as 'Képzési forma',
- count (*) as 'Hallgatók száma'
- from hallgatok
- group by kforma
- select nev, j.neptun, AVG(cast (jegy as float)) as'Átlag'
- from hallgatok h
- inner join
- jegyek j
- on h.neptun=j.neptun
- group by nev,j.neptun
- order by AVG(jegy)desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement