LeetCode 528 Variation | Dataford Interview Questions

How would you solve a variation of LeetCode 528?

Given a table of choices with positive, zero, or NULL weights and a supplied random_value, return the single choice whose weighted interval contains that value. Treat the random value as belonging to the half-open range from zero through, but not including, the total positive weight.

Output

Return one row with choice_id, choice_label, weight, cumulative_weight, and random_value.
Include only the selected choice, ordered by choice_id.

Schema

weighted_choices

Column	Type	Description
choice_idPK	INT	Stable identifier used to order choices
choice_label	VARCHAR(100)	Human-readable choice label
weight	NUMERIC(10,2)	Weight determining the size of the choice interval

Your question is LeetCode 528 Variation. 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

How would you solve a variation of LeetCode 528?

Output

Return one row with choice_id, choice_label, weight, cumulative_weight, and random_value.
Include only the selected choice, ordered by choice_id.

Schema

weighted_choices

Column	Type	Description
choice_idPK	INT	Stable identifier used to order choices
choice_label	VARCHAR(100)	Human-readable choice label
weight	NUMERIC(10,2)	Weight determining the size of the choice interval

Your question is LeetCode 528 Variation. 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.