We can't replace with IN a condition like major = 'History' OR name = 'Ava Smith', since it restricts two columns: major and name.
IN
major = 'History' OR name = 'Ava Smith'
major
name
Make sure to type name.