SQL row to column, SQL to Column

SQL row to column, SQL to Column

Row-to-Column

Table Structure:

Subject

Yw Language

Sx mathematics

Table data:

SQL conversion:

1 select name, 2 max (case subject when 'yw' then score else ''end) as yw, 3 max (case subject when 'sx 'then score else' end) as sx 4 from student_score group by name

Conversion Result:

Conversion process:

Groups students based on their names, and uses max to retrieve the values of corresponding subjects.

SQL statements have errors. Have you found them?