Use MySQL ROW_NUMBER() window function for multiple rows grouping to a single row using a CASE expression.
MySQL ROW_NUMBER() Window Function with CASE Expression
MySQL ROW_NUMBER() Window Function with CASE…
MySQL ROW_NUMBER() Window Function with CASE Expression
Use MySQL ROW_NUMBER() window function for multiple rows grouping to a single row using a CASE expression.