Average number of items per database - Notion SQL Query - Peliqan

Average number of items per database

SQL query for Notion

Calculate the average number of items per database.

SELECT AVG(items_count) FROM (SELECT database_id, COUNT(*) AS items_count FROM database_items GROUP BY database_id) AS counts;

Notion data model

Databases

Database Items

Pages

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.