Ludia chcu do svojich aplikacii ziskat celkove hodnotenie predmetov. Aby si nemuseli stale updatovat databazu na najnovsie data, stacilo by im poskytnut api, ktore by vracalo vysledky.
Query:

select code,name,slug,season_id,score from Subject,AnswerSummary,Question where AnswerSummary.subject_id=Subject.id and AnswerSummary.question_id=Question.id and isSubjectEvaluation=1;