Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Advanced
/
mondrian
/
query5380.q
blob: 74b5bf88d6927de6eeaabad81641ca835c270e6e [
file
] [
log
] [
blame
]
select
store
.
store_city
as
c0
from
store
as
store
where
(
store
.
store_state
=
'Zacatecas'
)
and
UPPER
(
store
.
store_city
)
=
UPPER
(
'Hidalgo'
)
group
by
store
.
store_city order
by
store
.
store_city ASC NULLS LAST
;