hi every one,,
i want to create tow variable to this sql :
dateof(sv.Inspection_start) >= var_01
dateof(sv.Inspection_start) <= var_02
----------------------------------------------------
select m.municipality_name, u.user_full_name,
count(distinct sv.store_visit_id) total,
ROUND(nvl(sum(Inspection_end - Inspection_start) 24 60,0),3) as dur_Per_min,
ROUND(nvl(avg(Inspection_end- Inspection_start) 24 60,0),3) as average_per_min
from store_visits sv, users u, municipalities m
where sv.visit_status = 1
and sv.Inspector = u.user_id
and u.municipality_id = m.municipality_id
and dateof(sv.Inspection_start) >= '2020-01-01'
and dateof(sv.Inspection_start) <= '2020-09-30'
and (Inspection_end - Inspection_start) * 60 < 600.0
group by sv.Inspector,m.municipality_name, u.user_full_name
order by m.municipality_name, sv.Inspector,u.user_full_name
------------------------------------
how i can do that