01

We can filter the wors with the keyword WHERE explained in Section 4 UPDATE / DELETE rows

SELECT * 
FROM student
WHERE major <> 'Biology';

02

another example using Comparison Operators explained in Section 4 2. Comparison Operators.

SELECT *
FROM student
WHERE name <> 'John' AND student_id > 3

This example finds any name not 'John' and the student id is greate than 3 (just confusing for practice)