Query editor
-- This query has been migrated to run on DuneSQL. If you need to change back because you’re seeing issues, use the Query History view to restore the previous version. If you notice a regression, please email [email protected].SELECT100 * cast(SUM(CASEWHEN status = 'filled'AND dynamic = TRUE THEN 1ELSE 0END) as double) / cast(SUM(CASEWHEN dynamic = TRUE THEN 1ELSE 0END) as double) AS dynamicRate,100 * SUM(CASEWHEN status = 'filled'AND dynamic = FALSE THEN 1ELSE 0END) / cast(SUM(CASEWHEN dynamic = FALSE THEN 1ELSE 0END) as double) AS fixedRateFROMreservoir.asks