4 Questions with corresponding queries
Each SQL query needs to include one or more explicit JOINs. The JOIN or JOINs should be necessary to the query. Each SQL query needs to include one or more aggregations. This could be a COUNT, AVG, SUM, or other aggregation. 2 of the 4 SQL queries need to include either a subquery OR a CTE. 1 of the 4 queries should use a Window Function. The SQL queries are well formatted and use aliases.
I'll post the 4 questions.
24 freelancer đang chào giá trung bình $145 cho công việc này
I have experience with different SQL tools, including PostgreSQL. I can write complex JOINs, nested queries and almost everything for an efficient operational Database.