Find Jobs
Hire Freelancers

SQL query modification.

€8-30 EUR

Inställt
Publicerad nästan fem år sedan

€8-30 EUR

Betalning vid leverans
Hello, Someone made me a query a while a go and now I need a little edit to it. The data is send from my game an its send in this format: Level_Started(Stage:0, Level:5) Level_Ended(Stage:0, Level:5) The game has multiple stages with multiple levels each stage: Stage 0 has 5 levels Stage 1 has 10 levels Stage 2 has 10 and so on In the current query It does not take in consideration the stages and counts up the starts of all levels 1 from all stages. Here is the image of how it should return the data. Here you have the current query in text: SELECT level, MAX(Launched) Launched, MAX(Retry) Retry, MAX(Doned) Doned, MAX(GameOver) GameOver, MAX(Exit) Exit, MAX(Restart) Restart, FROM ( SELECT event_params.value.int_value AS Level, (CASE WHEN event_name = 'Ball_Launch' THEN COUNT(event_params.value.int_value) END) AS Launched, (CASE WHEN event_name = 'Level_Retry' THEN COUNT(event_params.value.int_value) END) AS Retry, (CASE WHEN event_name = 'Level_Done' THEN COUNT(event_params.value.int_value) END) AS Doned, (CASE WHEN event_name = 'Level_Failed' THEN COUNT(event_params.value.int_value) END) AS GameOver, (CASE WHEN event_name = 'Stage_Exit' THEN COUNT(event_params.value.int_value) END) AS Exit, (CASE WHEN event_name = 'Stage_Retry' THEN COUNT(event_params.value.int_value) END) AS Restart FROM [analytics_181317890.events_20190402] WHERE [login to view URL] ="Level" AND [login to view URL] ="2.0" GROUP BY Level, event_name HAVING ( COUNT(event_params.value.int_value) >=0 ) ) GROUP BY level ORDER BY level
Project ID: 19298879

Om projektet

15 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
Dear Hiring Manager, I am an Oracle Certified Database Professional (OCP). I have complete masters in computer science. I am a database professional with 15 years’ experience. After carefully reviewing the experience requirements of the job description, I feel that I am suitable candidate for the job. My background includes Sql, MySQL, Pl Sql, Oracle, Access, SQL Server, Database, Normalization, ERD. I also bring strong computer proficiency in MS Word, MS Excel and CRM database applications. In addition to this experience, most recently I worked on a project where my responsibilities included handling database design and implementation, computer applications, software installations, PC Troubleshooting, solutions providing for software maintenance and updates. Thank you in advance for your time and consideration. Work Sample: Microsoft Access Database: [login to view URL] SQL MySQL: [login to view URL] Database Sample: [login to view URL] With Regards Md Zahedul Islam Database Expert
€23 EUR Om 1 dag
0,0 (0 omdömen)
0,0
0,0
15 frilansar lägger i genomsnitt anbud på €23 EUR för detta uppdrag
Använd avatar
Hi, I would like to modify your query to include stage. Available for discussion and ready to start now. Looking Forward to your response. Regards, Manish
€20 EUR Om 1 dag
4,9 (62 omdömen)
5,3
5,3
Använd avatar
I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database - SQL Server, Oracle, MySQL Dotnet - C#, ASP.Net, MVC, Javascripting etc... I can develop web application for you in asp.net with sql server. Let me know if you want to discuss further. My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
€29 EUR Om 1 dag
5,0 (23 omdömen)
4,8
4,8
Använd avatar
Hi. From your project declaration, its the kind of task that I have been experienced well. I have been experienced in programming including SQL since 2000. During 2006-2013, I had been senior developer for Financial system developed in MS Access backend with MS SQL server. I have been coded many advanced SQL functions and procedures and gained excellent experience with SQL. I can complete your task with high satisfaction of yours. I m ready to start. Hope to hear from you back, soon. Regards, Alta
€34 EUR Om 2 dagar
4,9 (4 omdömen)
4,3
4,3
Använd avatar
Hello I am a certified Database developer with over 7 years of experience in hand. i can help you on teamviwer and can explain you also what is the issue which will help you to manage this kind issue in future. i am ready to start. Manzoor
€15 EUR Om 1 dag
4,2 (6 omdömen)
4,0
4,0
Använd avatar
Dear Sir/Madam, I have relational database design and development experience of 10 years. Recently I completed 4 Database Systems Course projects which cover: - Conceptual design - Creation of database schema (creating tables, constraints) - Writing simple and complex SQL queries including subqueries. I am sure that I am a good fit for your project. Hope to hear from you soon. Best Regards Huseyin Aygun
€26 EUR Om 1 dag
5,0 (6 omdömen)
3,3
3,3
Använd avatar
Hi, I’m oracle certified SQL expert and have worked on many enterprises applications. I’m sure i can work on your query. Thank you!!
€26 EUR Om 1 dag
5,0 (1 omdöme)
1,5
1,5
Använd avatar
Hi, I have more than 8 years experience in database development, mainly SQL Server. I write SQL code daily and I am focused on database performance in general. If you give me the table structure I will modify the query for you. Sincerely, Lucian
€10 EUR Om 1 dag
5,0 (2 omdömen)
1,5
1,5
Använd avatar
Hey there, Hope you are doing well. We have gone through all the details of your project and after having necessary information to check our caliber, we have come to the result that we can make your project done successfully. You will tell us about your project's Deadline and if we will need any information about your project then we will send you texts right away, but before it, please make sure to send a message to us to discuss more about your project..!!! Thank you
€30 EUR Om 0 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hi we have worked on more than 13 projects based on procedural level statements execution , we are innovative and creative we can do the quality work and share you in respected timeline provided
€16 EUR Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hello. I cann do it for u. Pm me for discuss the details. .
€8 EUR Om 2 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I understood your problem and what you require and I have the solution. let us have a chat for further discussion.
€29 EUR Om 3 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för SPAIN
Malaga, Spain
5,0
5
Verifierad betalningsmetod
Medlem sedan feb. 3, 2018

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.