Can we have high level Executive Report for Project Statistics ?

Hi Super Team,

We looking forward your support to generate for us PGSQL query for high level Executive Report for Project Statistics as Project Bases.

What we looking for is have report by the end with below Requirements and details

(In attached file, the template that we did manually and we need same quarry for it.)

Project Name
Project Description/Details
Unite (Unite Name)
Project Manager
Project End Date (i.e 01/02/2021)
Project End Date By Quarter (Q1)
Delay/Ontime (i.e Based on Project Scheduled End, if the Project Scheduled End date crossed the today's date and status not closed it mean Delay, otherwise it mean on-time.)
# Task (Number of Tasks on Project)
# Task Completed (Number of Tasks Completed and Closed on Project)
# Milestone (Number of Milestone on Project)
# Milestone Completed (Number of Milestone Completed and Closed on Project)
% of Project Completion (Task Closed / Non-Closed )
Project Status (i.e Open, Closed, Onhold and etc)