blob: 06228e3952202c525defd0048184941813f6e763 [file] [log] [blame]
select customer.city as c0 from customer as customer where (customer.state_province = 'BC') and UPPER(customer.city) = UPPER('Shawnee') group by customer.city order by customer.city ASC NULLS LAST;