Skip to main content

Peliqan

Try for free
Request a demo

Aproplan Letsbuild

Average number of drawings per folder

SQL query for Aproplan Letsbuild

Calculate the average number of drawings in each folder.

SELECT folders.name, AVG(drawings.count) FROM folders LEFT JOIN drawings ON folders.id = drawings.folder_id GROUP BY folders.name

Try this query now in Aproplan Letsbuild

Aproplan Letsbuild data model

Aproplan Letsbuild
Project Ids

Aproplan Letsbuild
Projects

Aproplan Letsbuild
Chapters

Aproplan Letsbuild
Languages

Aproplan Letsbuild
Issuetypes

Aproplan Letsbuild
Folders

Aproplan Letsbuild
Contactdetails

Aproplan Letsbuild
Documents

Aproplan Letsbuild
Lists

Aproplan Letsbuild
Points

Aproplan Letsbuild
Drawings

Aproplan Letsbuild
Forms

Aproplan Letsbuild
Managedcompanies

Aproplan Letsbuild
Companyusers

Aproplan Letsbuild
Countries

Aproplan Letsbuild
Professions

Aproplan Letsbuild
Persons

Aproplan Letsbuild
Formitems

Aproplan Letsbuild
Point Status

Aproplan Letsbuild
Users

Aproplan Letsbuild
Locations

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