ou want to select author's last name from a table, but you only remember the author$$s last name starts with the letter B$,$ which string pattern can you use?

$1$ point

SELECT lastname from author where lastname like $$B#$$

SELECT lastname from author where lastname like $$B$\%$

SELECT lastname from author where lastname like $$B$$$

None of the above

$2.$

Question $2$

In a SELECT statement, which SQL clause controls how the result set is displayed?

$1$ point

ORDER BY clause

ORDER IN clause

ORDER WITH clause

$3.$

Question $3$

Which of the following can be used in a SELECT statement to restrict a result set?

$1$ point

HAVING

WHERE

DISTINCT

All of the above

$4.$

Question $4$

When querying a table called Author that contains a list of authors and their country of residence, which of the following queries will return the number of authors from each country?

$1$ point

SELECT Country, count$($Country$)$ FROM Author GROUP BY Country

SELECT Distinct$($Country$)$ FROM Author

SELECT Country, count$($Country$)$ FROM Author

SELECT Country, distinct$($Country$)$ FROM Author GROUP BY Country

$5.$

Question $5$

You want to retrieve a list of books that have between $450$ and $600$ pages. Which clause would you add to the following SQL statement:

SELECT Title, Pages FROM Book $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$1$ point

WHERE Pages $=450$

WHERE Pages $450600$

WHERE Pages $>=450$ and pages $<=600$

IF Pages $>=450$ and Pages $<=600$