group_by_with_where.sql « aggregate « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/aggregate/group_by_with_where.sql

blob: f6ec83308c21fb75654805568ef4c1ce8db86832 (plain) (blame)

1
2
3

/* syntax version 1 */
/* postgres can not */
SELECT ki, count(1) FROM plato.Input WHERE ki IN ('075', '150') GROUP BY key as ki ORDER BY ki;