Đã Hủy

SQL query modification.

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

Kĩ năng: Data Analysis, Data Analytics, SQL

Xem nhiều hơn: sql query tree structure records, asterisk call forward database sql query, sql query child child, how to edit sql database tables, alter command in sql syntax, modifying database objects, modification of the database in dbms, list the table modification commands in sql, update query in sql, modification of the database, joins in sql, sql query tree children, getafreelancer message sql query help needed, specialise sql query, sql query find number child elements, design sql query forum tree, simple sql query creator, sql query parent level, questions sql query oracle 10g, freelance sql query

Về Bên Thuê:
( 5 nhận xét ) Malaga, Spain

ID dự án: #19298879

Được trao cho:

databasedba

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 Thêm

€23 EUR trong 1 ngày
(0 Đánh Giá)
0.0

22 freelancer đang chào giá trung bình €24 cho công việc này

truongnguyen86

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!!

€50 EUR trong 1 ngày
(141 Nhận xét)
6.6
mahmoudgamal008

Can you please send me the correct desired results? As I don't understand what's wrong with the query now? I can fix it and customize it to you to get the results you are looking for. I can also make it pivot with Thêm

€30 EUR trong 0 ngày
(32 Nhận xét)
5.4
softcarve

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 trong 1 ngày
(57 Nhận xét)
5.3
Altantsetseg

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 Financi Thêm

€34 EUR trong 2 ngày
(4 Nhận xét)
4.3
huseyinaygun

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 Thêm

€26 EUR trong 1 ngày
(3 Nhận xét)
2.9
ManzoorH

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. Thêm

€15 EUR trong 1 ngày
(2 Nhận xét)
2.6
abfreelancec

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 Thêm

€15 EUR trong 1 ngày
(2 Nhận xét)
2.3
jayantavkumar

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 Thêm

€29 EUR trong 1 ngày
(3 Nhận xét)
2.0
MikeJones915

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. Thêm

€29 EUR trong 1 ngày
(2 Nhận xét)
1.9
rjghule

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 trong 1 ngày
(1 Nhận xét)
1.5
sergeyprince

i saw your project details and image. i have a history of developing website with using html, javascript, mysql, CI framework etc and i have a enough confident mysql working. i can finish this project in 30min . i w Thêm

€19 EUR trong 1 ngày
(2 Nhận xét)
1.1
shnexxx

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 Thêm

€10 EUR trong 1 ngày
(2 Nhận xét)
1.2
bluestar1027

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 Thêm

€23 EUR trong 1 ngày
(2 Nhận xét)
1.4
€29 EUR trong 1 ngày
(1 Nhận xét)
1.1
INDOGICSOLUTIONS

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 Thêm

€23 EUR trong 1 ngày
(0 Nhận xét)
0.0
dilipd1994

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 trong 3 ngày
(0 Nhận xét)
0.0
khurram4225

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 succe Thêm

€30 EUR trong 0 ngày
(0 Nhận xét)
0.0
naHuka

Hello. I cann do it for u. Pm me for discuss the details. .

€8 EUR trong 2 ngày
(0 Nhận xét)
0.0
venx08

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 Thêm

€14 EUR trong 1 ngày
(0 Nhận xét)
0.0
webdevangel

Hello ! thank you for your post. I have read the your description carefully. My skills are as followings. 1. mobile : android, iphone , PhoneGap, ionic, NWjs, Electron, Java, ObjectiveC. 2. front end : HTML5, b Thêm

€20 EUR trong 0 ngày
(0 Nhận xét)
0.0