SQ writing queries

In SQL how do I display only the columns LastName, FirstName, BusinessEntityID (show the output in that order) all rows?

Answer

It’s pretty simple:

Select LastName, FirstName, BusinessEntittyID from table_name 
order by LastName, FirstName, BusinessEntittyID