Sign in
apache
/
drill-test-framework
/
e7648f05ad9c828f9deacba058aefa394b901978
/
.
/
framework
/
resources
/
Advanced
/
mondrian
/
query2713.q
blob: d87f379d5c18a93321fe2e568d5ee213d676213c [
file
] [
log
] [
blame
]
select
customer
.
city
as
c0
from
customer
as
customer
where
(
customer
.
state_province
=
'WA'
)
and
UPPER
(
customer
.
city
)
=
UPPER
(
'Olympia'
)
group
by
customer
.
city order
by
customer
.
city ASC NULLS LAST
;