Đã Đóng

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

Kĩ năng: MySQL, PHP, Lập trình cơ sở dữ liệu, Kiến trúc phần mềm

Xem nhiều hơn: 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 )

Về Bên Thuê:
( 0 nhận xét ) Sibiu, Romania

ID dự án: #31883888

9 freelancer chào giá trung bình€30 cho công việc này

(49 Nhận xét)

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 Thêm

€19 EUR trong 7 ngày
(65 Nhận xét)
(8 Nhận xét)

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 Thêm

€30 EUR trong 3 ngày
(28 Nhận xét)

i can write this query message me urgent

€19 EUR trong 7 ngày
(15 Nhận xét)

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 trong 1 ngày
(11 Nhận xét)

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 trong 1 ngày
(4 Nhận xét)

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 Thêm

€40 EUR trong 7 ngày
(5 Nhận xét)

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 trong 1 ngày
(10 Nhận xét)