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

Beceriler: MySQL, PHP, Veritabanı Programlama, Yazılım Mimarisi

Daha fazlasını gör: 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 )

İşveren Hakkında:
( 0 değerlendirme ) Sibiu, Romania

Proje NO: #31883888

Bu iş için 9 freelancer ortalamada €30 teklif veriyor

(49 Değerlendirme)

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 Daha Fazla

€19 EUR in 7 gün içinde
(65 Değerlendirme)
(8 Değerlendirme)

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 Daha Fazla

€30 EUR in 3 gün içinde
(28 Değerlendirme)

i can write this query message me urgent

€19 EUR in 7 gün içinde
(15 Değerlendirme)

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(11 Değerlendirme)

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(4 Değerlendirme)

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 Daha Fazla

€40 EUR in 7 gün içinde
(5 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(10 Değerlendirme)