If you want the results of your query to appear in a specific order, you can use the ORDER BY clause
Select first_name, last_name
from employees
Order by last_name;
By default the SQL assumes Ascending order. You can make this more explicit by using the ASC or DESC keywords.
Select first_name, last_name
from employees
Order by last_name Desc;
You can also order by multiple columns
Select first_name, last_name, gender
from employees
Order by gender Desc, last_name Asc;