Tuning SQL

--- SELECT ALL ---

select * from page_errors;

--- SELECTED DATE ---

select to_char(a.request_datetime,'dd/mm/yyyy HH24:mi:ss'), a.* 

from page_errors a

where to_char(a.request_datetime,'yyyy-mm-dd HH24:mi') = '2023-02-13 10:50'

order by a.request_datetime desc;

--- HIGHEST REQUEST ---

select z.tarikh_masa, count(*) as bil

from (

select to_char(a.request_datetime,'yyyy-mm-dd HH24:mi') as tarikh_masa

from page_errors a

where to_char(a.request_datetime,'yyyy-mm-dd HH24:mi') >= '2023-02-09 12:00'

and to_char(a.request_datetime,'yyyy-mm-dd HH24:mi') <= '2023-02-13 23:59'

) z

group by z.tarikh_masa

order by bil desc;

-- order by z.tarikh_masa desc;