UpGuard's cyber risk analyst, Chris Vickery, discovers 198 million US voting records in an Amazon S3 bucket freely available online. One particular spreadsheet also calculates the voters probabilities for situations such as "how likely you are to have voted for a certain presidential candidate". This breach is another reminder of how important personal data security is.
I need to write query retrieve the loan number, state and city, customer first name for loans that
are in the states of CA,TX,FL,NV,NM but exclude the following cities (Dallas, SanFrancisco,
Oakland) and only return loans where customer first name begins with John.
I keep getting error syntax can .