Here is the complete code for the provided specification:

Using Subqueries and Joins to Calculate Player Points in PostgreSQL

Optimizing SQL Aggregation and Filtering for Better Performance

How to Fix the 'Query Returned More Than One Row' Error When Using INSERT ... RETURNING in PostgreSQL

Simplifying SQL Queries with Common Table Expressions (CTEs): A Powerful Technique for Improved Readability and Maintainability.

How to Find Profiles with More than 3 Photos but Not in Used Service Table Using SQL's EXISTS and NOT EXISTS Clauses

Optimizing Postgres Queries for Complex Search Criteria

Using ROW_NUMBER(), PARTITION_BY, and TOP/MAX to Get Maximum Values at Specific Positions in SQL

Dynamic Transpose for Unknown Row Value into Column Name on Postgres

How to Use Lateral Joins to Get the Most Recent Exchange Rate for Each Transaction in PostgreSQL