Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Advanced
/
mondrian
/
query2644.q
blob: 6433ce11d911452f6a1b3b729316fe7723b9a295 [
file
] [
log
] [
blame
]
select
customer
.
state_province
as
c0
from
customer
as
customer
where
(
customer
.
country
=
'Mexico'
)
and
UPPER
(
customer
.
state_province
)
=
UPPER
(
'Guerrero'
)
group
by
customer
.
state_province order
by
customer
.
state_province ASC NULLS LAST
;