+ 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.

26th Jan 2017, 1:40 AM
Djedje K. A. AZIADZO
Djedje K. A. AZIADZO - avatar
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.
26th Jan 2017, 2:56 AM
Kirk Schafer
Kirk Schafer - avatar
+ 2
sounds like homework
26th Jan 2017, 1:44 AM
jay
jay - avatar
+ 2
Thanks guys
28th Jan 2017, 9:17 PM
Djedje K. A. AZIADZO
Djedje K. A. AZIADZO - avatar
0
use the WHERE & AND statements
26th Jan 2017, 5:47 PM
Paramasivam
Paramasivam - avatar
0
SELECT CustomerID FROM Customer WHERE FirstName=LastName
30th Mar 2018, 12:54 PM
yado
yado - avatar