The query would fail if run against a case sensitive database due to myid and MyID being seen as two different columns in that case (Although nothing was specified so...

Good question - got it wrong, but learnt something so all to the good!

Never come across it before as I always use aliases, but good to know when I have...

Got this one right, but only after some googling and a bit of elimination based on what I already knew - I had to take an educated guess for the...

When I ran this - I got 1 row with a value of 10 which threw me a bit - although the query returns a count of the total rows,...