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
[login to view URL] 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
9 фрилансеров(-а) готовы выполнить эту работу в среднем за €30
Dear client, I can help you providing 2 mysql queries. I have seen your ER Diagram and am able to finish your work within timeframe. Ping me to start a chat. I can help you within 1 day. I am an algorithm expert.
HI there SQL professional expert here My last job offer here is SQL job(You can check my review) If you hire me you can save your time and money kindly ping me