Using AND OR NOT operator in SQL question answer

Using AND OR NOT operator in SQL question answer