Reason About Composite Join Keys and Predicate Placement
Company: Amazon
Role: Business Intelligence Engineer
Category: Data Manipulation (SQL/Python)
Difficulty: easy
Interview Round: Technical Screen
Overview: Reason about a two-column SQL join key and a right-side predicate without assuming a schema or join type. Compare inner- and left-join semantics, cardinality checks, and safe query shapes.
Read the full Amazon Business Intelligence Engineer interview experience this question came from
