With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"? SELECT * FROM Persons SORT BY 'FirstName' DESC SELECT * FROM Persons ORDER BY FirstName DESC SELECT * FROM Persons SORT 'FirstName' DESC SELECT * FROM Persons ORDER FirstName DESC

How would you sort the results by "amount" in descending order?SELECT * FROM expenses ORDER BY amount ASC; SELECT * FROM expenses ORDER BY amount DESC;SELECT * FROM expenses SORT BY amount DESC;SELECT * FROM expenses ORDER BY amount;

Which SQL clause is used to sort the result set in descending order based on one or more columns?

Choose the query to display names of the department in the college ordered in department_name in ascending order.select department_name from Department order by department_name asc;select department_name from Department order by name asc;select name from Department order by name;None of the listed optionsReview Answer

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

With SQL, how do you select a column named "FirstName" from a table named "Persons"?Select one:a.SELECT Persons.FirstNameb.SELECT FirstName FROM Personsc.EXTRACT FirstName FROM Personsd.SELECT FirstName.TableName FROM Personse.None of the answers are correct