SQL Data Analyst — Hard Which SQL feature allows you to pivot rows into columns dynamically without hardcoding column names? A Dynamic SQL with EXECUTE or sp_executesql B Static PIVOT operator C CASE WHEN aggregation D UNION ALL with fixed column aliases Show explanation
