+ 3
Will you be able to solve this question in SQL?
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.
5 Réponses
+ 3
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.
+ 2
sounds like homework
+ 2
Thanks guys
0
use the WHERE & AND statements
0
SELECT CustomerID FROM Customer WHERE FirstName=LastName