Finalization of a dashboard

We use a homemade CRM build upon the MVC framework Codeigniter v3. Technologies involved are Php 7, MySQL, javascript, HTML and CSS. We added an HMVC add-on to structure the code in modules. Currently our application has more than 200 modules and more than 300 database tables. We use GIT in our development process.

The landing page of the CRM shows some consolidated figures like monthly sales. We want to add other business data in the landing page. Your task will be to write SQL queries to gather data and to display results in tables and charts.