Sign in
apache
/
datafusion
/
refs/heads/fix-disable-migration-aggregate-default
/
.
/
benchmarks
/
sql_benchmarks
/
predicate_eval
/
queries
/
selectivity
/
q20.sql
blob: 3638f757a720dc1e5438d2869419facc5809cd4e [
file
]
-- Hidden: two equally cheap integer compares of unequal selectivity -- `c4 < 95`
-- matches ~95%, `c0 < 5` matches ~5%. Less selective one written first.
-- cf. q21 (opposite order).
SELECT
count
(*)
FROM
t
WHERE
c4
<
95
AND
c0
<
5
;