Skip to main content

Peliqan

Try for free
Request a demo

Monday

Average number of tasks per folder

SQL query for Monday

Calculate the average number of tasks per folder.

SELECT AVG(num_tasks) FROM (SELECT f.folder_id, COUNT(t.task_id) AS num_tasks FROM folders f LEFT JOIN tasks t ON f.folder_id = t.folder_id GROUP BY f.folder_id) AS avg_tasks

Try this query now in Monday

Monday data model

Monday
Boards

View 2 columns
IdString
NameString
Monday
Subitems Of Budget Test Board

View 8 columns
IdString
DateString
NameString
OwnerString
StatusString
Board_idString
Group_idString
Group_titleString
Monday
Budget Test Board

View 9 columns
IdString
DateDate-time
NameString
PersonString
StatusString
SubitemsString
Board_idString
Group_idString
Group_titleString
Monday
Subitems Of Test Board

View 8 columns
IdString
DateString
NameString
OwnerString
StatusString
Board_idString
Group_idString
Group_titleString
Monday
Test Board

View 10 columns
IdString
DateString
NameString
PersonString
StatusString
SubitemsString
Board_idString
Group_idString
Group_titleString
NikoTestColumnString
Monday
Folders

Monday
Users

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.

  • 14-day free trial
  • No credit card needed