Maks140888

Untitled

May 27th, 2022
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.22 KB | None | 0 0
  1. select u.name, t.title, listagg(g.grade, '% ')  from grades g, user_web u, solution s, task t
  2. where t.id = s.task_id
  3. and s.id = g.solution_id
  4. and s.student_id = u.id
  5. and g.grade = 0
  6. GROUP BY u.name, t.title
  7. order by t.title
Add Comment
Please, Sign In to add comment