Encerrado

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

Habilidades: MySQL, PHP, Programação de Banco de Dados, Arquitetura de software

Veja mais: 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 )

Acerca do Empregador:
( 0 comentários ) Sibiu, Romania

ID do Projeto: #31883888

9 freelancers estão ofertando em média €30 nesse trabalho

(49 Comentários)
6.1
santoshm143

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 Mais

€19 EUR in 7 dias
(65 Comentários)
6.7
(8 Comentários)
4.6
niarfedevelop

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 Mais

€30 EUR in 3 dias
(28 Comentários)
4.5
freelancersandh1

i can write this query message me urgent

€19 EUR in 7 dias
(15 Comentários)
4.2
Unitechsol

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 em 1 dia
(11 Comentários)
3.9
shilpichak16

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 em 1 dia
(4 Comentários)
3.9
temaural

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 Mais

€40 EUR in 7 dias
(5 Comentários)
3.6
novikovyaroslavd

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 em 1 dia
(10 Comentários)
3.6