Question

question 16 (6 points)
which item below is not a sql operator?
select 3
□ a &&
□ b ><
□ c =
□ d <
□ e ||
□ f >
□ g >=
□ h <<
house that professor belongs to.
sort the result alphabetically by the name of the course.
the resulting columns should be
ame\, \first_name\, \last_name\, \house\ where
ame\ is the name of the course.

1. from course join person join house
2. where person.house = house.id
3. select course.name, person.first_name, person.last_name, house.name as \house\
4. order by course.name;
5. and course.professor = person.id

Explanation:

In SQL, the operators like =, <, >, >=, || are common. However, && and >< and << are not SQL operators.

Answer:

a. &&, b. ><, h. <<