Untitled query #77781

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",log_action,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 log_action,MONTH(log_timestamp);



select * from logging
where log_type like "protect"
and MONTH(log_timestamp) in (10) 
  and YEAR(log_timestamp) = 2023
SQL

Checking query status...
