Dynamic Table SQL Output | Dataford Interview Questions

Explain how you would display data in a table where the column values are dynamic.

Use the provided flight and flight attribute data. Attribute names are not fixed in advance, so the result must preserve them dynamically rather than requiring a separate hardcoded column for each attribute.

Output

One row per flight with columns flight_id, flight_number, status, and dynamic_columns
dynamic_columns must contain each available attribute name and value for that flight
Include flights without attributes with an empty object, exclude orphaned attribute records, and order by flight_id ascending

Schema

flights

Column	Type	Description
flight_idPK	INT	Unique flight identifier
flight_number	VARCHAR(20)	Operational flight number
status	VARCHAR(20)	Current flight status

flight_attributes

Column	Type	Description
flight_idPK	INT	Flight receiving the attribute
attribute_namePK	VARCHAR(50)	Dynamic attribute key
attribute_value	VARCHAR(255)	Dynamic attribute value

Your question is Dynamic Table SQL Output. Start with the requirements and the two tables 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