Computer Packages interview question

basic SQL algorithm, such as select and order the result.