Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
create table scores 
(
    name varchar2(15), 
    history_grade varchar2(1), 
    math_grade varchar2(1)
);
BEGIN
insert into scores (name, history_grade, math_grade) values ('Bill', 'A', 'A');
insert into scores (name, history_grade, math_grade) values ('Sue', 'F', 'F');
insert into scores (name, history_grade, math_grade) values ('Mary', 'C', 'B');
insert into scores (name, history_grade, math_grade) values ('Austin', 'C', 'A');
insert into scores (name, history_grade, math_grade) values ('Kyle', 'B', 'B');
END;
/
1 rows affected

SELECT * 
FROM   scores 
WHERE  (history_grade, math_grade) NOT IN (('A', 'A'), ('F', 'F'));


NAME
HISTORY_GRADE
MATH_GRADE


Mary
C
B

Austin
C
A

Kyle
B
B


SELECT * 
FROM   scores 
WHERE  NOT ( history_grade = 'A' AND math_grade = 'A' )
AND    NOT ( history_grade = 'F' AND math_grade = 'F' );


NAME
HISTORY_GRADE
MATH_GRADE


Mary
C
B

Austin
C
A

Kyle
B
B


SELECT * 
FROM   scores 
WHERE  ( history_grade <> 'A' OR math_grade <> 'A' )
AND    ( history_grade <> 'F' OR math_grade <> 'F' );


NAME
HISTORY_GRADE
MATH_GRADE


Mary
C
B

Austin
C
A

Kyle
B
B