Jump to content

SQL Aliases Exercise


rose123

Recommended Posts

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;
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...