Question $3(1$ point$)$

Which predicate keyword is not used in combination with a comparison operator?

Question $3$ options:

IN

SOME

ALL

ANY

Question $4(1$ point$)$

In what clause of a SELECT statement is the JOIN specified?

Question $4$ options:

WHERE

HAVING

SELECT

FROM

Question $5(1$ point$)$

What keyword is used to link two dissimilar tables on matching column values?

Question $5$ options:

EXCEPT

UNION

INTERSECT

JOIN

Question $6(1$ point$)$

Which of the following is a request that can be answered using a subquery?

Question $6$ options:

Create a list that combines agents and entertainers.

Display products and the latest date the product was ordered.

Show me the students who have a grade of $85$ or better in Art together with the faculty members who teach Art and have a proficiency rating of $9$ or better.

Create an index list of all the recipe classes, recipe titles, and ingredients.