I have a complex query where I'm grouping by different items. To keep the grouping separate, I'm using partition over by clause.

While typing I accidentally put 22 instead of 99. I've edited my numbers.

Create table main
(name varchar,
member_type_id integer)

Following are the values in main table.
Name                member_type_id
Sara ...