Query to Get Count Value based on Time Interval

Query to Get Count Value based on Time Interval

I have table just like this :

I have table just like this :

p_central_ticket
================
- t_id              ======>   id ticket
- t_open_by         ======>   name that raise the ticket
- t_closed_by       ======>   name that closed the ticket 
- t_open_time       ======>   open ticket time
- t_closed_time     ======>   closed ticket time

How should i do, if i want to show the Count all tickets that closed by name, and closed time today, weekly, monthly and yearly ? Just like this :

    Name                today      weekly     monthly     yearly     
=================================================================   
[email protected]         2           10          70        1000         
[email protected]         5           14          60        1234

Sample data :

t_id      t_open_by      t_closed_by       t_open_time        t_closed_time
===========================================================================
 1     [email protected]   [email protected]   2018-03-28          2018-03-29
 2     [email protected]   [email protected]   2018-04-28          2018-05-29

Need Help guys... Thanks

Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

MySQL Database Bootcamp: Go from SQL Beginner to Expert | Simpliv

MySQL Database Bootcamp: Go from SQL Beginner to Expert

SQL Full Course - SQL Tutorial For Beginners - MySQL Essentials - SQL Training

This SQL Full Course video will cover all the topics of SQL starting from scratch. This video is great for beginners who want to learn SQL and for advanced people to brush up their skills.

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts|Simpliv

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts