Which options when used with the above SQL statement can produce the sorted output in ascending order…