Logical Operators

You can also use logical operators. For example, if you wanted to find students whose attendance count is greater than 80 in English, you can run this statement.

xxxxxxxxxx

SELECT studentname 

FROM   class 

WHERE  attendance > 80 

       AND coursesenrolled = 'English'