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 UNION ALL with fixed column aliases D CASE WHEN aggregation Show explanation
