SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE SkillQuiz(
  [Coder] VARCHAR(50),
  [Subject] VARCHAR(50),
  [Score] INT
)

INSERT INTO SkillQuiz VALUES
('Bob','SQL',95),
('Bob','Python',80),
('Bob','Java',77),
('Emily','SQL',98),
('Emily','Python',90),
('Emily','Java',100)
6 rows affected

SELECT *
FROM SkillQuiz;


Coder
Subject
Score


Bob
SQL
95

Bob
Python
80

Bob
Java
77

Emily
SQL
98

Emily
Python
90

Emily
Java
100


SELECT *
FROM (
	SELECT [Coder]
		,[Subject]
		,[Score]
	FROM SkillQuiz
	) AS SkillQuizResults
pivot(SUM([Score]) FOR [Subject] IN (
			SQL
			,Python
			,Java
			)) AS PivotTable


Coder
SQL
Python
Java


Bob
95
80
77

Emily
98
90
100


INSERT INTO SkillQuiz VALUES
('Bob','JavaScript',85),
('Emily','JavaScript',70)
2 rows affected

SELECT *
FROM (
    SELECT [Coder]
        ,[Subject]
        ,[Score]
    FROM SkillQuiz
    ) AS SkillQuizResults
PIVOT(SUM([Score]) FOR [Subject] IN (
            SQL
            ,Python
            ,Java
            ,JavaScript
            )) AS PivotTable


Coder
SQL
Python
Java
JavaScript


Bob
95
80
77
85

Emily
98
90
100
70


SELECT *
FROM (
	SELECT [Coder]
		,[Subject]
		,[Score]
	FROM SkillQuiz
	) AS SkillQuizResults
PIVOT(SUM([Score]) FOR [Coder] IN (
			Bob
			,Emily
			)) AS PivotTable


Subject
Bob
Emily


Java
77
100

JavaScript
85
70

Python
80
90

SQL
95
98


SELECT Coder
	,MAX(CASE Subject
			WHEN 'SQL'
				THEN Score
			ELSE 0
			END) AS SQL
	,MAX(CASE Subject
			WHEN 'Python'
				THEN Score
			ELSE 0
			END) AS Python
	,MAX(CASE Subject
			WHEN 'Java'
				THEN Score
			ELSE 0
			END) AS Java
	,MAX(CASE Subject
			WHEN 'JavaScript'
				THEN Score
			ELSE 0
			END) AS JavaScript
FROM SkillQuiz
GROUP BY Coder


Coder
SQL
Python
Java
JavaScript


Bob
95
80
77
85

Emily
98
90
100
70


SELECT Subject
	,MAX(CASE Coder
			WHEN 'Bob'
				THEN Score
			ELSE 0
			END) AS Bob
	,MAX(CASE Coder
			WHEN 'Emily'
				THEN Score
			ELSE 0
			END) AS Emily
FROM SkillQuiz
GROUP BY Subject


Subject
Bob
Emily


Java
77
100

JavaScript
85
70

Python
80
90

SQL
95
98
Coder	Subject	Score
Bob	SQL	95
Bob	Python	80
Bob	Java	77
Emily	SQL	98
Emily	Python	90
Emily	Java	100