Sum From 1 to 1,000,000 | Dataford Interview Questions

Virtu Financial's Triton platform maintains a validation table containing integer sequence values used in data-quality checks. Write a PostgreSQL query to calculate the sum of every integer from 1 through 1,000,000, inclusive.

The sequence_values table contains one row for each required integer. It may also contain NULL values or values outside the target range, which must not affect the result.

Requirements

Sum only values between 1 and 1,000,000, inclusive.
Return one row with the result under the alias total_sum.

Schema

sequence_values

Column	Type	Description
value_idPK	BIGINT	Unique row identifier
sequence_value	INTEGER	Integer value used in the validation sequence

Your question is Sum From 1 to 1,000,000. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

The sequence_values table contains one row for each required integer. It may also contain NULL values or values outside the target range, which must not affect the result.

Requirements

Sum only values between 1 and 1,000,000, inclusive.
Return one row with the result under the alias total_sum.

Schema

sequence_values

Column	Type	Description
value_idPK	BIGINT	Unique row identifier
sequence_value	INTEGER	Integer value used in the validation sequence

Your question is Sum From 1 to 1,000,000. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.