How to group statistics data monthly using CTE (Common Table Expressions) in Laravel

Table of contents:

• # Watch tutorial
• # Code
• # Useful links

# Watch tutorial

# Code

# Useful links

staudenmeir/laravel-cte - Composer package to add CTE to Laravel

https://learnsql.com/blog/sql-recursive-cte/

https://sqlfordevs.com/statistical-results-fill-gaps

https://chasingcode.dev/blog/mysql-cte-group-by-year-month-with-gaps/

https://chasingcode.dev/blog/mysql-laravel-cte-group-by-year-month-with-gaps/