Question

Question 1
A data analyst at a recycling company manually recalculates the new column materials_sorter. They want to identify any rows with values that do not match those in the original column, compost_sorter. Which SQL clauses would enable them to do so? Select all that apply.



WHERE materials_sorter >< compost_sorter



WHERE materials_sorter <> compost_sorter



WHERE materials_sorter !! compost_sorter



WHERE materials_sorter != compost_sorter


1 point

Answer 1

Correct answers:
- WHERE materials_sorter <> compost_sorter
- WHERE materials_sorter != compost_sorter

Both <> and != are valid SQL not-equal operators. The other two are not valid.