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:
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:
event_params.value.int_value AS Level,
WHEN event_name = 'Ball_Launch' THEN COUNT(event_params.value.int_value) END) AS Launched,
WHEN event_name = 'Level_Retry' THEN COUNT(event_params.value.int_value) END) AS Retry,
WHEN event_name = 'Level_Done' THEN COUNT(event_params.value.int_value) END) AS Doned,
WHEN event_name = 'Level_Failed' THEN COUNT(event_params.value.int_value) END) AS GameOver,
WHEN event_name = 'Stage_Exit' THEN COUNT(event_params.value.int_value) END) AS Exit,
WHEN event_name = 'Stage_Retry' THEN COUNT(event_params.value.int_value) END) AS Restart
[login to view URL] ="Level"
AND [login to view URL] ="2.0"
( COUNT(event_params.value.int_value) >=0 ) )
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 Daha Fazla
Bu iş için 22 freelancer ortalamada €24 teklif veriyor
Hello there, i'm expert on writing complex queries, let me help you with this. Pls share me also the tables and data. Waiting for your response if interested. Thank you!!
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
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 (creat Daha Fazla
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. Daha Fazla
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9.5 years experience in MS SQL Server and 6.8 years experience in SSRS, SSIS (Import / Export). Please let me know more details and Daha Fazla
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, Jav Daha Fazla
Hi I read your requirements carefully. I have experience in query. If you give me the assignment, I will satisfy u with good result. If you want to, I can show you the source code of the tasks I have already done. Daha Fazla
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!!
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 Daha Fazla
Hi Dear. Don't worry for your project, i can do your project completely. Because of i'm dedicated and created developer for project and love to develop for you. if you don't satisfy my result, i will return your mon Daha Fazla
Greetings!! With over 12 years of producing corporate marketing projects for some of the most innovative companies in world, I’m here to bring your ideas and vision to life. I have the ability to communicate efficie Daha Fazla
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
Over 10 years experience in Database Development, Performance Tuning and Data Modeler. Experienced in handle BFSI, healthcare projects with crucial data. Solution export - easily crack the problem and will prov Daha Fazla