SQL: Display all information using OR, NOT operator with specified conditions

SQL Boolean Operator Statement: Exercise-4 with Solution

From the following table, write a SQL query to find customers who are either from the city 'New York' or who do not have a grade greater than 100. Return customer_id, cust_name, city, grade, and salesman_id.

Sample table: customer

Sample Solution:

SELECT * 
FROM customer 
WHERE city = 'New York' OR NOT grade>100;

Output of the Query:

customer_id	cust_name	city		grade   salesman_id
3002		Nick Rimando	New York	100	5001
3007		Brad Davis	New York	200	5001
3009		Geoff Cameron	Berlin		100	5003

Relational Algebra Expression:

Relational Algebra Tree:

Explanation:

Pictorial presentation:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following table, write a SQL query to find the customers who belong to either the city ‘New York’ or have a grade above 100. Return customer_id, cust_name, city, grade, and salesman_id.
Next: From the following table, write a SQL query to find those customers who belong to neither the ‘New York’ city nor their grade value exceeds 100. Return customer_id, cust_name, city, grade, and salesman_id.