SAQL / PIGQL Order Query Statement - Salesforce Analytics Cloud

When starting to use the order statement in my pigql queries I was running into issues where I couldnt return an ascending or descending order on my calculation or query outcomes.

An example of the type of scenario I was using can be seen below:

In the documentation it doesnt really provide a working example of how we would use the order statement in a full query. An example of a working version can be seen below.

The difference between the working and not working version is basically that we have previously projected those output columns. Hopefully this helps someone having issues in building a query where they need to order the results.