How to select multiple columns based on a condition in SQL?

Learn how to select multiple MySQL columns using WHERE, CASE, conditional aggregation, and dynamic SQL, with working queries and practical fixes.