with loc_1 as (SELECT cast(datestr_start as date) as date_month, index_nsa as 'FL' FROM real_estate.freddie_mac_house_price_index WHERE geo_name = 'FL'), loc_2 as (SELECT cast(datestr_start as date) as date_month, index_nsa as 'CA' FROM real_estate.freddie_mac_house_price_index WHERE geo_name = 'CA') SELECT loc_1.date_month, loc_1.`fl`, loc_2.`ca` FROM loc_1 join loc_2 ON loc_1.date_month = loc_2.date_month WHERE loc_1.date_month >= '2010-01-01' ORDER BY loc_1.date_month desc