There are two options in the order by clause of the sql statement. You can either have ASC (ascending) or DESC (descending). For ASC, if it is numeric, it will go from lowest to highest and if it is characters, it will go alphabetically. For DESC, if it is numeric, it will go from highest to lowest and if it is characters, it will go reverse alphabetical.