Understanding SELECT/COUNT Statements and Subqueries in PostgreSQL for Efficient Database Development