Mysql Select

€8-30 EUR

Đã hoàn thành

Đã đăng vào

hơn 5 năm trước

€8-30 EUR

Thanh toán khi bàn giao

Hi, I have 3 Tables, where I need to extract data from: Table: Users [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL] Table: Projects projects.user_id, projects_name Table: Counts counts.project_id, counts.user_id, [login to view URL] [login to view URL] = projects.user_id [login to view URL] = counts.project_id [login to view URL] = counts.user_id In counts, I have several user_ids to the same project_id -> this should be sum([login to view URL]) I need a Select which provides the following data: from users: name, vorname, title, anr, email, firma from projects: name (where stat = 2) from counts: sum of counts and all the other projects which are not in counts but have stat = 2 So in the End, all of the 764 Rows should be in a table, correctly sum (0 if not in table counts).

Database Programming

MySQL

PHP

Software Architecture

SQL

Mã dự án: 18529240

Về dự án

10 đề xuất

Dự án từ xa

Hoạt động 5 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@sumon355

Hello, As an expert in SQL, i am very much interested to write the required select query. Looking forward to have a positive response from you. Thanks

€26 EUR trong 0 ngày

5,0

(324 nhận xét)

7,7

10 freelancer chào giá trung bình €23 EUR cho công việc này

@customizedata

I have gone through the description. 1- Select statement will fetch counts (sum) based upon user. Created select statement will have all 764 rows.. Please have a chat with me so that i could discuss with you.. I will start right now.

€25 EUR trong 1 ngày

5,0

(232 nhận xét)

7,3

@seefattechnologi

Hello!! I have 5+ years experience experience in SQL Server Database Design, Database Maintenance, developing SQL queries, stored procedures using SQL Server. I have been working with all version starting from 2005 server. Expertise in development of Web Applications with LINQ. Proficient in Jquery, JavaScript, HTML, AJAX. Looking from positive response from your side. Thanks

€29 EUR trong 1 ngày

4,9

(61 nhận xét)

6,5

@AsifShimon

hi, i have worked with sql databases including mysql and postgresql. i think i can create the sql statements you've asked. let me know if you are interested.

€30 EUR trong 1 ngày

4,9

(26 nhận xét)

4,4

@dalsaniyasonu123

Hello, I am ready to discuss project with you. Being experienced in working on several Web projects related to core php/codeigniter/wordpress etc. Based on that i can quickly help you in getting your project done as you mentioned in the description. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Sapna Dalsaniya

€28 EUR trong 1 ngày

4,9

(16 nhận xét)

4,0

@ranzhie07

Hi i can do the job in a day or less please consider my bid bro i have 5 years of professional experience in web and windows app development Thanks bro

€22 EUR trong 1 ngày