non-orm-queries.md

select emn.aar as year, emn.terminkode as term, count(*) as evaluted_courses, emn_total.total_courses
      from emne_liste emn,
        (select str.kode, CAST(LEFT(rap.filnavn, 4) as INTEGER) year
        from rapport rap, struktur str
        where rap.struktur_id = str.struktur_id) eval,
        (select aar, terminkode, count(*) as total_courses
         from emne_liste
         GROUP BY aar, terminkode) emn_total
      where emn.emnekode = eval.kode
            and emn.aar = eval.year
            and emn.aar = emn_total.aar
            and emn.terminkode = emn_total.terminkode
      GROUP BY emn.aar, emn.terminkode
      ORDER BY emn.aar DESC;