yogi_How To Handle Field With Mixed Data Type While ORDERing This Field Using QUERY Function

Google Spreadsheet   Post  #2422

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-12-2018

question by: Krist_chat
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/B4hWffMJRgI;context-place=mydiscussions

Creating a "Query How To" ... stuck on order by
Hi All,

I'm creating a short and basic 'how to' guide for beginning query users. Ran into an unexpected issue with 'order by' as it's only working when I have a 'where' included. Please see this Sample Workbook, specifically the 'quick reference' tab and the associated number tab #4.

Feel free to add any simple examples if you've found them helpful. I'm trying to think of the basic ones that are used frequently when beginning to work with query. Maybe add an average or something?

Thank you!

Kristi