Search results
Exercise 6. SQL. Tasks: elementary. SqlSum. VIEW START. Calculate sum of elements. easy. SqlEventsDelta. VIEW START. Compute the difference between the latest and the second latest value for each event type. medium. SqlWorldCup. VIEW START.
- SqlSum
Given a table elements with the following structure:. create...
- SqlWorldCup
SqlWorldCup. Given a list of matches in a group stage of the...
- Training Task
Sign up to start the Training Sign up to track your...
- SqlEventsDelta
write an SQL query that, for each event_type that has been...
- Exercise 5 Coding Skills
Exercise 5 Coding Skills - Exercise 6. SQL - Practice Coding...
- Exercise 8 Frontend
Become a strong tech candidate online using Codility!...
- 2017 Contest
2017 Contest - Exercise 6. SQL - Practice Coding - Codility
- Exercise 7 Data Structures
Exercise 7 Data Structures - Exercise 6. SQL - Practice...
- SqlSum
Code written while solving exercises and challenges on Codility. Codility is a technical recruitment platform for teams to test the coding skills of developers.
17 kwi 2022 · If a team wins a match (scores strictly more goals than the other team), it receives three points. If a team draws a match (scores exactly the same number of goals as the opponent), it receives one point. If a team loses a match (scores fewer goals than the opponent), it receives no points.
There were like 3-5 questions to be answered using queries. They all referred to the same DB. Most were about computing some kpis on a transactions dataset or finding top N countries/products/employees.
SqlSegmentsSum. START. Compute the total length covered by 1-dimensional segments. Programming language: You are given a table segments with the following structure: create table segments ( l integer not null, r integer not null, check (l <= r), unique (l,r) );
I took a codility test for sql to work for a company. it was the sensor_events test. My code worked for the sample test they wanted us to use, but no for correctness.
SqlWorldCup. Given a list of matches in a group stage of the soccer World Cup, compute the number of points each team currently has. You are given two tables, teams and matches, with the following structures: Each record in the table teams represents a single soccer team.
