Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE "church-members" (
ID NUMBER(10),
NAME varchar(30)  NOT NULL,
LOGIN varchar(20)  NOT NULL,
PASS  varchar(12)  NOT NULL,
REGISTER_YEAR_MONTH varchar(15)  NOT NULL,
USER_SCORE NUMBER(10),
PRIMARY KEY (ID));
INSERT INTO "church-members" VALUES
('1', 'John Doe', 'John', 'Xo8*d_d%f58*', '202204','1');
1 rows affected

INSERT INTO "church-members" VALUES
('2', 'Mary Doe', 'Mary', 'dLoc&257dsew', '202203','2');
1 rows affected

INSERT INTO "church-members" VALUES
('3', 'Robertson III', 'Robertson', 'koIIf59*Liu*', '202203','7');
1 rows affected

INSERT INTO "church-members" VALUES
('4', 'Sonia MacDonald', 'Sonia', 'fYhfgtdjfi%', '202204','4');
1 rows affected

INSERT INTO "church-members" VALUES
('5', 'Boris Johnston', 'Boris', 'do*&flddkIK%', '202201','2');
1 rows affected

INSERT INTO "church-members" VALUES
('6', 'Ruth Henderson', 'Ruth', 'dF6%*&', '202202','2');
1 rows affected

SELECT 
    ID,
    NAME,
    LOGIN,
    MAX(CASE WHEN REGISTER_YEAR_MONTH = '202203' THEN TO_CHAR(USER_SCORE) ELSE '' END) AS "MARCH SCORE",
    MAX(CASE WHEN REGISTER_YEAR_MONTH = '202204' THEN TO_CHAR(USER_SCORE) ELSE '' END) AS "APRIL SCORE "
FROM 
    "church-members" 

GROUP BY 
    ID,
    NAME,
    LOGIN


ID
NAME
LOGIN
MARCH SCORE
APRIL SCORE


1
John Doe
John
null
1

2
Mary Doe
Mary
2
null

5
Boris Johnston
Boris
null
null

6
Ruth Henderson
Ruth
null
null

4
Sonia MacDonald
Sonia
null
4

3
Robertson III
Robertson
7
null

ID	NAME	LOGIN	MARCH SCORE	APRIL SCORE
1	John Doe	John	null	1
2	Mary Doe	Mary	2	null
5	Boris Johnston	Boris	null	null
6	Ruth Henderson	Ruth	null	null
4	Sonia MacDonald	Sonia	null	4
3	Robertson III	Robertson	7	null