kacaii.dev / senac-brigade-server
wip: currently rewriting the project as a full stack application tangled.org/kacaii.dev/sigo
gleam
fork atom
senac-brigade-server / src / app / domain / dashboard / sql / query_dashboard_stats.sql
at main 10 lines 430 B view raw
kacaii.dev :art: lowercase all sql code
61f7a9ea
1-- 󱘟 Retrieve stats for the Dashboard page 2select 3 (select count from public.vw_count_active_brigades) 4 as active_brigades_count, 5 (select count from public.vw_count_total_occurrences) 6 as total_occurrences_count, 7 (select count from public.vw_count_active_occurrences) 8 as active_occurrences_count, 9 (select count from public.vw_count_recent_occurrences) 10 as recent_occurrences_count;