Top 50 data relationships Interview Questions

Given two tables, write a query to find users who haven't made a transaction in the last 30 days. Use PostgreSQL's CURRENTDATE as the reference date. Trea...

data relationshipsDate Functionsnull handlingAirwallexCCleo (United Kingdom)Freecharge

Return every employee with the name of their manager, including employees whose manager_id is NULL.

data relationshipsnull handlingJoinsSSAP LabsOracle

Model product features by combining current lifecycle status, project relationships, and a derived implementation stage.

data relationshipsData Wranglingdata managementAutodeskAirbnb

Use a self-join to return each mutual follower pair once, with the lower user ID first.

data relationshipsnull handlingJoinsBee RoboticsSupermicro

Audit user, application, and event relationships to validate completeness and referential integrity.

data relationshipsJoinsData WranglingMercer Francebet365

Find Flipkart customers with no orders in the prior six months using a LEFT JOIN and date-filtered aggregation.

data relationshipsuser retentionsql queriesFlipkartPNC Financial Services Group