PostgreSQL group x, sort by y, and get (N dynamic) Records for Each Group-Subquery + Subquery Aggregation Use

This short article explains PostgreSEL group filtering and aggregation usage.

PostgreSQL Multi-meaning Array Retrieval and Condition Filtering

This post describes how can we efficiently search tags and filter records that match the tag's weighted value.