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

Навыки: MySQL, PHP, Программирование баз данных, Архитектура ПО

Показать больше: building xml files mysql queries, optimize mysql queries, oscommerce mysql queries pproducts_model, complex php mysql queries, optimize mysql queries script, php mysql queries css instead tabs, send mysql queries perl, oscommerce mysql queries, cacti mysql queries, mysql queries locked state, sanitizing mysql queries php, optimize mysql queries phpbb3, mysql queries spike, mysql queries basis users input, php sanitize mysql queries, iphone app mysql queries, magento 2 there is no data for the export., magento 2 there is no data for the export, part 2 - send arduino data to the web ( php/ mysql/ d3.js )

О работодателе:
( 0 отзыв(-а, -ов) ) Sibiu, Romania

ID проекта: #31883888

9 фрилансеров(-а) готовы выполнить эту работу в среднем за €30

(49 отзывов(-а))

Hi Hope you are amazing. I have vast experience working with Php and Laravel. I have 7+ years of professional experience in this field. I can handle any type of work in Php and Laravel. I have done similar work in my Больше

€19 EUR за 7 дней(-я)
(65 отзывов(-а))
(8 отзывов(-а))

Hello, I would like to help you, I have more than 10 years of experience working with MYSQL, POSTGRESQL, SQL SERVER, MARIADB, in many of its versions. It is my specialty en SQL y PL/SQL. Relational database expert. Vis Больше

€30 EUR за 3 дней(-я)
(28 отзывов(-а))

i can write this query message me urgent

€19 EUR за 7 дней(-я)
(15 отзывов(-а))

I am ready to start your project immediately and I have flexible working hours. I am available for chat/voice Interview to discuss this job further.

€20 EUR за 1 день
(11 отзывов(-а))

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.

€30 EUR за 1 день
(4 отзывов(-а))

I've been working for a database designer for 5 years I have been experienced realtional databases like mysql, oracle, mssql. I am the one who came up with the idea of MongoDB the document oriented database. I also hav Больше

€40 EUR за 7 дней(-я)
(5 отзывов(-а))

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

€30 EUR за 1 день
(10 отзывов(-а))