mysql怎么实现with as

with

cr as (     select CountryRegionCode from person.CountryRegion where Name like 'C%' )

select * from person.StateProvince where CountryRegionCode in (select * from cr)