First page Back Continue Last page Image

Using WHERE clause AND operator

Here I asked “Show me the Planets that are close to the size of Earth”

The First condition eliminated the smaller planets and the 2nd condition added with the AND eliminated the larger planets

AND

Condition 1

Condition 2

Also notice here that I can evaluate any field even if I did not Select it for output