00:00:00

Description

Editorial

Catalog Products with Isolated Three-Digit Blocks

EASY10 pts

A merchandising analytics team is validating product naming conventions before a catalog release.

Table: Products

product_id: unique product identifier
name: product display name

A product is considered a match if its name contains at least one isolated block of exactly three digits.

A three-digit block is isolated when:

It has exactly three consecutive characters in [0-9].
The character immediately before the block (if it exists) is not a digit.
The character immediately after the block (if it exists) is not a digit.

Examples:

"AXE123PRO" is a match (contains isolated block "123").
"Pack1234" is not a match (the digit run has length 4, not exactly 3).
"003" is a match (length-3 run at full-string boundaries).

Task: Return every row from Products that matches this rule.

Output requirements:

Return columns in this exact order:
- product_id
- name
Sort by product_id in ascending order.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

Products:
| product_id | name              |
|------------|-------------------|
| 1          | AXE123PRO         |
| 2          | A12B34C           |
| 3          | Mega56789Pack     |
| 4          | 789Starter        |
| 5          | Item003Label      |
| 6          | NoDigitsHere      |

Output

[
  {"product_id":1,"name":"AXE123PRO"},
  {"product_id":4,"name":"789Starter"},
  {"product_id":5,"name":"Item003Label"}
]

Explanation

Rows 1, 4, and 5 each contain at least one isolated 3-digit block. Rows 2 and 6 have no 3-digit run, and row 3 has a 5-digit run.

Example

Input

Products:
| product_id | name           |
|------------|----------------|
| 10         | X123Y456Z      |
| 11         | X1234Y         |
| 12         | AB001-CD       |
| 13         | 99123A         |
| 14         | A1B2C3         |

Output

[
  {"product_id":10,"name":"X123Y456Z"},
  {"product_id":12,"name":"AB001-CD"}
]

Explanation

Rows 10 and 12 have isolated 3-digit runs. Rows 11 and 13 contain longer digit runs, and row 14 never reaches three consecutive digits.

Example

Input

Products:
| product_id | name      |
|------------|-----------|
| 21         | 123       |
| 22         | 1234      |
| 23         | A000B     |
| 24         | A0000B    |
| 25         | AB12      |

Output

[
  {"product_id":21,"name":"123"},
  {"product_id":23,"name":"A000B"}
]

Explanation

Full-string boundaries still count as isolated boundaries. Any 4-digit run is rejected.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in Products <= 200000
product_id is unique within a test case
1 <= product_id <= 1000000000
name is a non-null text value
1 <= LENGTH(name) <= 120
Digit checks are ASCII-based ([0-9])
A matching run must be exactly length 3 with non-digit boundaries (or string boundaries)
Output columns must be exactly: product_id, name
Final order must be product_id ASC
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with columns [product_id, name]

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

Products =

[{"product_id":1,"name":"AXE123PRO"},{"product_id":2,"name":"A12B34C"},{"product_id":3,"name":"Mega56789Pack"},{"product_id":4,"name":"789Starter"},{"product_id":5,"name":"Item003Label"},{"product_id":6,"name":"NoDigitsHere"}]

Loading problem...

101

00:00:00

Description

Editorial

Catalog Products with Isolated Three-Digit Blocks

EASY10 pts

A merchandising analytics team is validating product naming conventions before a catalog release.

Table: Products

product_id: unique product identifier
name: product display name

A product is considered a match if its name contains at least one isolated block of exactly three digits.

A three-digit block is isolated when:

It has exactly three consecutive characters in [0-9].
The character immediately before the block (if it exists) is not a digit.
The character immediately after the block (if it exists) is not a digit.

Examples:

"AXE123PRO" is a match (contains isolated block "123").
"Pack1234" is not a match (the digit run has length 4, not exactly 3).
"003" is a match (length-3 run at full-string boundaries).

Task: Return every row from Products that matches this rule.

Output requirements:

Return columns in this exact order:
- product_id
- name
Sort by product_id in ascending order.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

Products:
| product_id | name              |
|------------|-------------------|
| 1          | AXE123PRO         |
| 2          | A12B34C           |
| 3          | Mega56789Pack     |
| 4          | 789Starter        |
| 5          | Item003Label      |
| 6          | NoDigitsHere      |

Output

[
  {"product_id":1,"name":"AXE123PRO"},
  {"product_id":4,"name":"789Starter"},
  {"product_id":5,"name":"Item003Label"}
]

Explanation

Rows 1, 4, and 5 each contain at least one isolated 3-digit block. Rows 2 and 6 have no 3-digit run, and row 3 has a 5-digit run.

Example

Input

Products:
| product_id | name           |
|------------|----------------|
| 10         | X123Y456Z      |
| 11         | X1234Y         |
| 12         | AB001-CD       |
| 13         | 99123A         |
| 14         | A1B2C3         |

Output

[
  {"product_id":10,"name":"X123Y456Z"},
  {"product_id":12,"name":"AB001-CD"}
]

Explanation

Rows 10 and 12 have isolated 3-digit runs. Rows 11 and 13 contain longer digit runs, and row 14 never reaches three consecutive digits.

Example

Input

Products:
| product_id | name      |
|------------|-----------|
| 21         | 123       |
| 22         | 1234      |
| 23         | A000B     |
| 24         | A0000B    |
| 25         | AB12      |

Output

[
  {"product_id":21,"name":"123"},
  {"product_id":23,"name":"A000B"}
]

Explanation

Full-string boundaries still count as isolated boundaries. Any 4-digit run is rejected.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in Products <= 200000
product_id is unique within a test case
1 <= product_id <= 1000000000
name is a non-null text value
1 <= LENGTH(name) <= 120
Digit checks are ASCII-based ([0-9])
A matching run must be exactly length 3 with non-digit boundaries (or string boundaries)
Output columns must be exactly: product_id, name
Final order must be product_id ASC
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with columns [product_id, name]

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

Products =

Catalog Products with Isolated Three-Digit Blocks

Hints

Catalog Products with Isolated Three-Digit Blocks

Hints