Sequential grouping of database table rows in postgreSql

“This post assumes that you have a basic understanding of SQL queries, PostgreSQL , aggregated functions like GROUP BY, conditional expressions like CASE, and window functions.” In one of the projects I worked, we had a PostgreSQL(version 9.