SQL Aliases Exercise

[rose123]

The exercise below asks for the answer AS Pno.  The only reason I know that is that I clicked on the show answer button.  My answer, was AS Zip, which is what we shorten Postal code to in the US.  I had never heard of Pno until today.  I couldn't even find that abbreviation on the web.  What I found was planned non-operation, which is a choice for type of vehicle registration here.  How was I supposed to get this correct?

 

SELECT CustomerName,
Address,
PostalCode 
FROM Customers;

[Ingolme]

I can't see what the exercise actually was, but for learning purposes, the alias you use should not matter at all. Most likely it was the syntax that was incorrect.