By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
Coder | Subject | Score |
---|---|---|
Bob | SQL | 95 |
Bob | Python | 80 |
Bob | Java | 77 |
Emily | SQL | 98 |
Emily | Python | 90 |
Emily | Java | 100 |
Coder | SQL | Python | Java |
---|---|---|---|
Bob | 95 | 80 | 77 |
Emily | 98 | 90 | 100 |
2 rows affected
Coder | SQL | Python | Java | JavaScript |
---|---|---|---|---|
Bob | 95 | 80 | 77 | 85 |
Emily | 98 | 90 | 100 | 70 |
Subject | Bob | Emily |
---|---|---|
Java | 77 | 100 |
JavaScript | 85 | 70 |
Python | 80 | 90 |
SQL | 95 | 98 |
Coder | SQL | Python | Java | JavaScript |
---|---|---|---|---|
Bob | 95 | 80 | 77 | 85 |
Emily | 98 | 90 | 100 | 70 |
Subject | Bob | Emily |
---|---|---|
Java | 77 | 100 |
JavaScript | 85 | 70 |
Python | 80 | 90 |
SQL | 95 | 98 |