Find Jobs
Hire Freelancers

SQL query modification.

€8-30 EUR

Annullato
Pubblicato quasi 5 anni fa

€8-30 EUR

Pagato al completamento
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
Rif. progetto: 19298879

Info sul progetto

15 proposte
Progetto a distanza
Attivo 5 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
15 freelance hanno fatto un'offerta media di €23 EUR
Avatar dell'utente
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 in 1 giorno
4,9 (62 valutazioni)
5,3
5,3
Avatar dell'utente
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 in 1 giorno
5,0 (23 valutazioni)
4,8
4,8
Avatar dell'utente
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 in 2 giorni
4,9 (4 valutazioni)
4,3
4,3
Avatar dell'utente
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 in 1 giorno
4,2 (6 valutazioni)
4,0
4,0
Avatar dell'utente
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 in 1 giorno
5,0 (6 valutazioni)
3,3
3,3
Avatar dell'utente
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 in 1 giorno
5,0 (1 valutazione)
1,5
1,5
Avatar dell'utente
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 in 1 giorno
5,0 (2 valutazioni)
1,5
1,5
Avatar dell'utente
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 in 0 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hello. I cann do it for u. Pm me for discuss the details. .
€8 EUR in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
I understood your problem and what you require and I have the solution. let us have a chat for further discussion.
€29 EUR in 3 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: SPAIN
Malaga, Spain
5,0
5
Metodo di pagamento verificato
Membro dal feb 3, 2018

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.