must’ve forgotten something along the way, but how come when selecting all the names starting with S they’re all unique without using the ‘distinct’ clause?
I’m not certain how the results are checked but you’d get a different response without ordering the output which may be why it was not accepted. I’m not sure why you chose ‘X’ as an upper bound for between but you could potentially get the same result if you skipped the ordering though it’s worth bearing in mind that your current query could cause problems with a different dataset (e.g. a smaller one).
) below!
) to up-vote the contribution!