Indeed Interview Question

SQL exercise - write a simple query using AND/OR