Query to include Task Info

I would like to make queries like «Projects with 0 open tasks», tables that show task count for an object etc. Need better high level views on tasks.