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 
  */
  
  show tables;
SQL

Checking query status...
