(CASE WHEN tab.positionId::text = '0095' THEN 1 ELSE 0 END) tax_professional_count, SUM(CASE WHEN tab.positionId::text = '0100' THEN 1 ELSE 0 END) attorney_count, SUM(CASE WHEN tab.positionId::text = '0090' THEN 1 ELSE 0 END) non_attorney_count,...
SELECTsite_id, date_trunc('minute', ingest_time)asminute,COUNT(1)ASrequest_count,SUM(CASEWHEN(status_codebetween200and299)THEN1ELSE0END)assuccess_count,SUM(CASEWHEN(status_codebetween200and299)THEN0ELSE1END)aserror_count,SUM(response_time_msec) /COUNT(1)ASaverage_response_time_msecFROMhttp_...