WHERE name LIKE 'A%' -- any name begins with A
WHERE name LIKE 'A_' -- same, but only 2 letters

WHERE grade >= 80 AND grade <=90;
WHERE grade BETWEEN 80 AND 90;

WHERE grade BETWEEN 80 AND 90 AND class = 1;

WHERE grade BETWEEN 80 AND 90 AND
(class = 1 or class = 2);
WHERE grade BETWEEN 80 AND 90 AND
(class IN (1,2));