Dataset: city, state, county zip, Lat, Lng, Population, Area, Timezone, children, Age, Income, Marital, Gender, Outage_sec_perweek, Email, contacts, Yearly_equip_failure, Techie, Customer service, trust and security, limited payment, User Experience, Communication, competition, pricing strategy, product variety

1. using SQL extract relevant information such as Customer service, trust and security, limited payment, User Experience, Communication, competition, pricing strategy, product variety from the company database.

Note: provide SQL code to extract the information

2. Describe data collection preparation process and provide screenshots to illustrate each step. using python