Untitled query #77774

SQL

select count(*) from logging
where log_type like "protect"
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023;


select count(*),MONTH(log_timestamp) as "month" from logging
where log_type like "protect"
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023
group  by MONTH(log_timestamp);


select count(*),MONTH(log_timestamp) as "month",log_action from logging
where log_type like "protect"
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023
group  by MONTH(log_timestamp),log_action;
SQL

Checking query status...
