Mysql Select

€8-30 EUR

Ολοκληρώθηκε

Αναρτήθηκε

πάνω από 5 χρόνια πριν

€8-30 EUR

Πληρωμή κατά την παράδοση

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

Ταυτότητα εργασίας: 18529240

Σχετικά με την εργασία

10 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@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 σε 0 ημέρα

5,0

(324 αξιολογήσεις)

7,7

10 freelancers δίνουν μια μέση προσφορά €23 EUR για αυτή τη δουλειά

@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 σε 1 ημέρα

5,0

(232 αξιολογήσεις)

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 σε 1 ημέρα

4,9

(61 αξιολογήσεις)

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 σε 1 ημέρα

4,9

(26 αξιολογήσεις)

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 σε 1 ημέρα

4,9

(16 αξιολογήσεις)

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 σε 1 ημέρα