Untitled query #77774

SQL

# العدد الكلي في شهر ٩ و ١٠
select count(*) as "count" from logging
where log_type like "protect"
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023;

# العدد الكلي موزع حسب الشهر
select count(*) as "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(*) as "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;

# العدد الكلي موزع حسب الشهر ونوع التعديل واسم المستخدم
select count(*) as "count",MONTH(log_timestamp) as "month",log_action,actor.actor_name from logging
inner join actor on actor.actor_id = logging.log_actor
where log_type like "protect"
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023
group  by MONTH(log_timestamp),log_action,log_actor;
SQL

Checking query status...
