Advertisement
Guest User

Untitled

a guest
Oct 18th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.57 KB | None | 0 0
  1. SELECT
  2.     temp.task_id,
  3.     tags.name as task_label,
  4.     task_time_spent,
  5.     task_time_spent / labels as labels_on_task
  6. FROM
  7. (
  8.     SELECT
  9.         task_log.task_id,
  10.         SUM(time_spent) as task_time_spent,
  11.         COUNT(DISTINCT tag_id) as labels
  12.     FROM task_log
  13.     INNER JOIN task_effort on task_effort.task_log_id = task_log.id
  14.     INNER JOIN task_tags on task_tags.task_id = task_log.task_id
  15.     INNER JOIN tags on tags.id = task_tags.tag_id
  16.     GROUP BY task_log.task_id
  17. ) AS temp
  18. INNER JOIN task_tags on task_tags.task_id = temp.task_id
  19. INNER JOIN tags on tags.id = task_tags.tag_id
  20. GROUP BY task_label
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement