1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-08-07 03:22:57 +03:00
Files

9 lines
285 B
Plaintext

USE tpch1;
Select o_orderpriority, min(o_orderstatus), max(o_orderstatus) from orders where o_orderkey < 1000000 group by o_orderpriority order by o_orderpriority;
o_orderpriority min(o_orderstatus) max(o_orderstatus)
1-URGENT F P
2-HIGH F P
3-MEDIUM F P
4-NOT SPECIFIED F P
5-LOW F P