Oracle 21c

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

CREATE TABLE t
    (MEMBER_ID int, COUNTRY_ID varchar2(2))
;
INSERT ALL 
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (93, 'AU')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (45, 'US')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (56, 'AU')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (98, 'AU')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (99, 'US')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (45, 'US')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (11, 'US')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (12, 'US')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (13, 'US')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (14, 'DE')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (15, 'ZW')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (16, 'ZW')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (17, 'US')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (18, 'DE')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (19, 'DE')
    INTO t (MEMBER_ID, COUNTRY_ID)
         VALUES (31, 'DE')
SELECT * FROM dual
;
16 rows affected

SELECT * FROM t


MEMBER_ID
COUNTRY_ID


93
AU

45
US

56
AU

98
AU

99
US

45
US

11
US

12
US

13
US

14
DE

15
ZW

16
ZW

17
US

18
DE

19
DE

31
DE


select *
from   t
pivot(count(MEMBER_ID) for COUNTRY_ID in('AU' as "count(AU)", 'US' as "count(US)", 'LAO' as "count(LAO)", 'IND' as "count(IND)", 'DE' as "count(DE)", 'ZW' as "count(ZW)")) p  


count(AU)
count(US)
count(LAO)
count(IND)
count(DE)
count(ZW)


3
7
0
0
4
2

MEMBER_ID	COUNTRY_ID
93	AU
45	US
56	AU
98	AU
99	US
45	US
11	US
12	US
13	US
14	DE
15	ZW
16	ZW
17	US
18	DE
19	DE
31	DE

MEMBER_ID	COUNTRY_ID
93	AU
45	US
56	AU
98	AU
99	US
45	US
11	US
12	US
13	US
14	DE
15	ZW
16	ZW
17	US
18	DE
19	DE
31	DE

MEMBER_ID	COUNTRY_ID
93	AU
45	US
56	AU
98	AU
99	US
45	US
11	US
12	US
13	US
14	DE
15	ZW
16	ZW
17	US
18	DE
19	DE
31	DE