aggregates Coding Problems

All C# Programs — Data Structures 167 DSA — Strings 105 DSA — Dynamic Programming 105 DSA — Graphs 105 DSA — Trees 105 DSA — Two Pointers 105 DSA — Stacks & Queues 105 DSA — Sorting 105 DSA — Binary Search 105 DSA — Hashing 105 C# Programs — Strings 105 C# Programs — Arrays 105 DSA — Arrays 105 C# Programs — LINQ 104 C# Programs — Sorting 103 C# Programs — Collections 103 C# Programs — OOP 103 C# Programs — Interfaces 101 SQL Server — SELECT basics 101 SQL Server — CTEs 101 SQL Server — Window functions 101 SQL Server — Indexes & plans 101 SQL Server — JOINs 101 C# Programs — Inheritance 101 SQL Server — Aggregates & GROUP BY 101 SQL Server — T-SQL procedures 101 SQL Server — WHERE & filtering 101 SQL Server — DDL & constraints 101

255 problems in this topic

#	Title	Topics	Acceptance	Pts	Difficulty
1	Average salary by department	SQL — Aggregates & GROUP BY sql coding-practice	—	30	Medium	Solve
2	MySQL SELECT with LIMIT	MySQL — Aggregates & GROUP BY mysql coding-practice	—	20	Easy	Solve
3	MySQL SELECT with LIMIT	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	20	Easy	Solve
4	PostgreSQL SELECT with ILIKE	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	20	Easy	Solve
5	Departments with total salary > 100000	SQL — Aggregates & GROUP BY sql coding-practice	—	40	Hard	Solve
6	Avg by category #1	SQL — Aggregates & GROUP BY sql coding-practice	—	40	Hard	Solve
7	MySQL AVG salary by dept #1	MySQL — Aggregates & GROUP BY mysql coding-practice	—	40	Hard	Solve
8	PostgreSQL GROUP BY HAVING #1	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	40	Hard	Solve
9	T-SQL AVG salary by department #1	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	40	Hard	Solve
10	Avg by category #2	SQL — Aggregates & GROUP BY sql coding-practice	—	30	Medium	Solve
11	MySQL AVG salary by dept #2	MySQL — Aggregates & GROUP BY mysql coding-practice	—	30	Medium	Solve
12	PostgreSQL GROUP BY HAVING #2	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	30	Medium	Solve
13	T-SQL AVG salary by department #2	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	30	Medium	Solve
14	Avg by category #3	SQL — Aggregates & GROUP BY sql coding-practice	—	30	Medium	Solve
15	MySQL AVG salary by dept #3	MySQL — Aggregates & GROUP BY mysql coding-practice	—	30	Medium	Solve
16	PostgreSQL GROUP BY HAVING #3	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	30	Medium	Solve
17	T-SQL AVG salary by department #3	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	20	Easy	Solve
18	Avg by category #4	SQL — Aggregates & GROUP BY sql coding-practice	—	40	Hard	Solve
19	MySQL AVG salary by dept #4	MySQL — Aggregates & GROUP BY mysql coding-practice	—	40	Hard	Solve
20	PostgreSQL GROUP BY HAVING #4	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	40	Hard	Solve
21	T-SQL AVG salary by department #4	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	30	Medium	Solve
22	Avg by category #5	SQL — Aggregates & GROUP BY sql coding-practice	—	30	Medium	Solve
23	MySQL AVG salary by dept #5	MySQL — Aggregates & GROUP BY mysql coding-practice	—	30	Medium	Solve
24	PostgreSQL GROUP BY HAVING #5	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	30	Medium	Solve
25	T-SQL AVG salary by department #5	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	40	Hard	Solve
26	Avg by category #6	SQL — Aggregates & GROUP BY sql coding-practice	—	30	Medium	Solve
27	MySQL AVG salary by dept #6	MySQL — Aggregates & GROUP BY mysql coding-practice	—	30	Medium	Solve
28	PostgreSQL GROUP BY HAVING #6	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	30	Medium	Solve
29	T-SQL AVG salary by department #6	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	30	Medium	Solve
30	Avg by category #7	SQL — Aggregates & GROUP BY sql coding-practice	—	40	Hard	Solve
31	MySQL AVG salary by dept #7	MySQL — Aggregates & GROUP BY mysql coding-practice	—	40	Hard	Solve
32	PostgreSQL GROUP BY HAVING #7	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	40	Hard	Solve
33	T-SQL AVG salary by department #7	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	20	Easy	Solve
34	Avg by category #8	SQL — Aggregates & GROUP BY sql coding-practice	—	30	Medium	Solve
35	MySQL AVG salary by dept #8	MySQL — Aggregates & GROUP BY mysql coding-practice	—	30	Medium	Solve
36	PostgreSQL GROUP BY HAVING #8	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	30	Medium	Solve
37	T-SQL AVG salary by department #8	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	30	Medium	Solve
38	Avg by category #9	SQL — Aggregates & GROUP BY sql coding-practice	—	30	Medium	Solve
39	MySQL AVG salary by dept #9	MySQL — Aggregates & GROUP BY mysql coding-practice	—	30	Medium	Solve
40	PostgreSQL GROUP BY HAVING #9	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	30	Medium	Solve
41	T-SQL AVG salary by department #9	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	40	Hard	Solve
42	Avg by category #10	SQL — Aggregates & GROUP BY sql coding-practice	—	40	Hard	Solve
43	MySQL AVG salary by dept #10	MySQL — Aggregates & GROUP BY mysql coding-practice	—	40	Hard	Solve
44	PostgreSQL GROUP BY HAVING #10	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	40	Hard	Solve
45	T-SQL AVG salary by department #10	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	30	Medium	Solve
46	Avg by category #11	SQL — Aggregates & GROUP BY sql coding-practice	—	30	Medium	Solve
47	MySQL AVG salary by dept #11	MySQL — Aggregates & GROUP BY mysql coding-practice	—	30	Medium	Solve
48	PostgreSQL GROUP BY HAVING #11	PostgreSQL — Aggregates & GROUP BY postgresql coding-practice	—	30	Medium	Solve
49	T-SQL AVG salary by department #11	SQL Server — Aggregates & GROUP BY sqlserver coding-practice	—	20	Easy	Solve
50	Avg by category #12	SQL — Aggregates & GROUP BY sql coding-practice	—	30	Medium	Solve

Problem of the day

Graph Valid Tree

Medium · +15 pts

Solve today

Weekly leaderboard

View all

Be the first to climb the board this week.

Company sheets

Toolliyo unique — practice by hiring company.

Google Amazon Microsoft Meta Apple Netflix TikTok LinkedIn Nvidia Uber

Browse all companies

Interview path

DSA Interview 150 All roadmaps 3,700+ Interview Q&A

Problems explorer