You want to retrieve a list of employees in alphabetical order of Lastname from the Employees table. Which SQL statement should you use?

$1$ point

SELECT $*$ FROM Employees GROUP BY Lastname;

SELECT $*$ FROM Employees SORT BY Lastname;

SELECT $*$ FROM Employees ORDER BY Lastname;

SELECT $*$ FROM Employees ORDER BY Lastname DESC;

$2.$

Question $2$

Which of the following keyword should be used in order to set a filtering condition, when using GROUPBY clause?

$1$ point

WHERE

ORDER BY

HAVING

SELECT

$3.$

Question $3$

You want to retrieve a list of authors from Australia, Canada, and India from the table Authors. Which SQL statement is correct?

$1$ point

SELECT $*$ FROM Author IF Country $($Australia$,$ 'Canada', 'India'$)$;

SELECT $*$ FROM Author WHERE Country IN $($Australia$,$ 'Canada', 'India'$)$;

SELECT $*$ FROM Author WHERE Country BETWEEN$($Australia$,$Canada$,$India$)$;

SELECT $*$ FROM Author WHERE Country LIST $(\text{'}$CA$\text{'},\text{'}$IN$\text{'})$;

$4.$

Question $4$

You want to retrieve a list of books priced in the range $$10$ to $$25$ from the table Book. What are the two ways you can specify the range?

$1$ point

SELECT Title, Price FROM Book WHERE Price $>=10$ and Price $<=25$;

SELECT Title, Price FROM Book WHERE Price $10$ to $25$;

SELECT Title, Price FROM Book WHERE Price IN $(10,25)$;

SELECT Title, Price FROM Book WHERE Price BETWEEN $10$ and $25$;

$5.$

Question $5$

You want to retrieve Salary information for an employee called Ed from the Employee table. You write the following statement:

SELECT Firstname, Lastname, Salary FROM Employees

You see all the employees listed, and it$$s hard to find Ed$$s information. Which clause should you add to reduce the number of rows returned?

$1$ point

WHERE Employees $=$Ed$$;

GROUP BY Firstname $=$Ed$$;

ORDER BY Firstname;

WHERE Firstname $=$Ed$$;