Will you be able to solve this question in SQL?

Question

Due to manual entry errors, the first name of some customers has been copied over to the LastName column. Identify the IDs of customers who have their first name and last name identical, but focused only on the customers in Yellowknife.

Answer 1

If you don't have access to a SQL engine you can experiment with basic SQL in my web code here:

https://code.sololearn.com/WUg6o4QaxPGU/?ref=app

It runs inside the SoloLearn app and I just fixed it for the website.

You would of course have to create/load tables like the problem, but a few rows should do.

Answer 2

sounds like homework

Answer 3

Thanks guys

Answer 4

use the WHERE & AND statements

Answer 5

SELECT CustomerID FROM Customer WHERE FirstName=LastName