2 MySQL queries
Budget: €8 – €30 EUR
I have a mariaDB, and I need 2 queries for some statistics.
The queries should return :
1. a query to export top 10 most parent task order by effort contribution along with the effort on each and the number of interactions and how many tasks integrated in that initiative (effort and interactions should be also added for all child tasks) number of users participating in the project
- Tabel: task_name, total_effort, number_of_interactions, number_of_tasks, number_of_users
2.Write a query to return top 5 labels based on effort contributed in a specific time range
Split task effort when multiple labels equal per label attached to the task
NOTE: Just 1 query for each point, without CTE’s
I need the task done as soon as possible.
Database diagram is in attachments
The queries should return :
1. a query to export top 10 most parent task order by effort contribution along with the effort on each and the number of interactions and how many tasks integrated in that initiative (effort and interactions should be also added for all child tasks) number of users participating in the project
- Tabel: task_name, total_effort, number_of_interactions, number_of_tasks, number_of_users
2.Write a query to return top 5 labels based on effort contributed in a specific time range
Split task effort when multiple labels equal per label attached to the task
NOTE: Just 1 query for each point, without CTE’s
I need the task done as soon as possible.
Database diagram is in attachments