Find Jobs
Hire Freelancers

Mysql Select

€8-30 EUR

Dokončeno
Zveřejněno přibližně před 5 roky

€8-30 EUR

Zaplaceno při doručení
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).
IČ projektu: 18529240

O projektu

10 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
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 v 0 dni
5,0 (324 recenze)
7,7
7,7
10 freelanceři nabízejí v průměru €23 EUR za tuto práci
Avatar uživatele
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 v 1 dni
5,0 (232 recenze)
7,3
7,3
Avatar uživatele
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 v 1 dni
4,9 (61 recenze)
6,5
6,5
Avatar uživatele
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 v 1 dni
4,9 (26 recenze)
4,4
4,4
Avatar uživatele
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 v 1 dni
4,9 (16 recenze)
4,0
4,0
Avatar uživatele
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 v 1 dni
4,5 (7 recenze)
3,1
3,1
Avatar uživatele
................................... ........................................... .............................
€23 EUR v 1 dni
5,0 (3 recenze)
2,7
2,7

O klientovi

Pochází z AUSTRIA
Wien, Austria
5,0
45
Ověřená platební metoda
Členem od kvě 15, 2017

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.