--- format:markdown ... #Basic pSQL commands to access GOLEM data ## Last 100 discharges: ~~~~ SELECT * FROM public.shots ORDER BY shot_no DESC LIMIT 100 ~~~~ ## Search for the longest discharge: ~~~~ SELECT shot_no,t_plasma_duration FROM public.shots WHERE t_plasma_duration>1 ORDER BY t_plasma_duration DESC LIMIT 100 ~~~~