What is the state of each address?
select state_province_county from addresses
What one has building name that contains "6862 Kaitlyn Knolls"?
select state_province_county from addresses where line_1_number_building like "%6862 kaitlyn knolls%"