Trouble with Select Distinct() FROM Sub Select

[Shuja Ali]

There is no need for the sub-query. You could just do this

SELECT Distinct AccountNo FROM Customers WHERE Name LIKE 'a%'