Average details per collection - Postman SQL Query - Peliqan

Average details per collection

SQL query for Postman

Calculate the average number of details per collection.

SELECT AVG(num_details) FROM (SELECT c.collection_id, COUNT(cd.detail_id) AS num_details FROM collections c JOIN collection_details cd ON c.collection_id = cd.collection_id GROUP BY c.collection_id) AS temp

Postman data model

Collections

Collection Details

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.