00:00:00

Description

Editorial

Highest Unique Signal Value

EASY10 pts

You are given a SignalReadings table with one column:

reading_value (integer)

The table may contain duplicate values. A value is considered unique if it appears exactly once in the full table.

Task:

Return the largest unique value in the dataset.
If no unique value exists, return NULL.

Return exactly one row with this schema:

largest_unique_value

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

SignalReadings:
| reading_value |
|---------------|
| 8             |
| 8             |
| 3             |
| 3             |
| 1             |
| 4             |
| 5             |
| 6             |

Output

[{"largest_unique_value":6}]

Explanation

Unique values are 1, 4, 5, and 6. The largest among them is 6.

Example

Input

SignalReadings:
| reading_value |
|---------------|
| 8             |
| 8             |
| 7             |
| 7             |
| 3             |
| 3             |
| 3             |

Output

[{"largest_unique_value":null}]

Explanation

Every value appears at least twice, so no unique value exists.

Example

Input

SignalReadings:
| reading_value |
|---------------|
| -10           |
| -10           |
| -2            |
| 0             |
| 0             |
| 9             |
| 9             |

Output

[{"largest_unique_value":-2}]

Explanation

The only value that appears exactly once is -2, so it is returned.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in SignalReadings <= 10,000
-1,000,000,000 <= reading_value <= 1,000,000,000
SignalReadings has no guaranteed primary key
Duplicate rows are allowed
Return exactly one row and one column: largest_unique_value
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a one-row DataFrame with column largest_unique_value

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

signalreadings =

[{"reading_value":8},{"reading_value":8},{"reading_value":3},{"reading_value":3},{"reading_value":1},{"reading_value":4},{"reading_value":5},{"reading_value":6}]

Loading problem...

101

00:00:00

Description

Editorial

Highest Unique Signal Value

EASY10 pts

You are given a SignalReadings table with one column:

reading_value (integer)

The table may contain duplicate values. A value is considered unique if it appears exactly once in the full table.

Task:

Return the largest unique value in the dataset.
If no unique value exists, return NULL.

Return exactly one row with this schema:

largest_unique_value

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

SignalReadings:
| reading_value |
|---------------|
| 8             |
| 8             |
| 3             |
| 3             |
| 1             |
| 4             |
| 5             |
| 6             |

Output

[{"largest_unique_value":6}]

Explanation

Unique values are 1, 4, 5, and 6. The largest among them is 6.

Example

Input

SignalReadings:
| reading_value |
|---------------|
| 8             |
| 8             |
| 7             |
| 7             |
| 3             |
| 3             |
| 3             |

Output

[{"largest_unique_value":null}]

Explanation

Every value appears at least twice, so no unique value exists.

Example

Input

SignalReadings:
| reading_value |
|---------------|
| -10           |
| -10           |
| -2            |
| 0             |
| 0             |
| 9             |
| 9             |

Output

[{"largest_unique_value":-2}]

Explanation

The only value that appears exactly once is -2, so it is returned.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in SignalReadings <= 10,000
-1,000,000,000 <= reading_value <= 1,000,000,000
SignalReadings has no guaranteed primary key
Duplicate rows are allowed
Return exactly one row and one column: largest_unique_value
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a one-row DataFrame with column largest_unique_value

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

signalreadings =

[{"reading_value":8},{"reading_value":8},{"reading_value":3},{"reading_value":3},{"reading_value":1},{"reading_value":4},{"reading_value":5},{"reading_value":6}]

Highest Unique Signal Value

Hints

Highest Unique Signal Value

Hints