2 MySQL queries

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