Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

13. Repeated Values in Sequence (Medium)
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Problem Statement

Table: Sequence

Each row in this table represents a sequence of numbers with a unique ID and a value for each position in the sequence.

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| id          | int     |
| value       | int     |
+-------------+---------+
id is the primary key for this table.
This table may contain duplicate values in the 'value' column.

Develop a solution to find all values that appear at least three times consecutively in the sequence.

Return the result table in any order.

Example

Input:

`

.....

.....

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible