Advertisement
Maks140888

Untitled

May 27th, 2022
845
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.21 KB | None | 0 0
  1. select u.name, t.title, 10/(min(g.grade_date)-min(s.sent_date))
  2. from grades g, user_web u, solution s, task t
  3. where  s.id = g.solution_id
  4.     and g.tutor_id = u.id
  5.     and t.id = s.task_id
  6. group by u.name, t.title
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement