SQL: Find customers who are from the city of New York or have a grade of over 100

SQL Boolean Operator Statement: Exercise-3 with Solution.

From the following table, write a SQL query to find customers who are from the city of New York or have a grade of over 100. Return customer_id, cust_name, city, grade, and salesman_id.

Sample table: customer

Sample Solution :

SELECT * 
FROM customer 
WHERE city = 'New York' OR 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
3005		Graham Zusi	California	200		5002
3008		Julian Green    London		300		5002
3004		Fabian Johnson  Paris		300		5006
3003		Jozy Altidor    Moscow		200		5007

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 all the customers in ‘New York’ city who have a grade value above 100. Return customer_id, cust_name, city, grade, and salesman_id.
Next: From the following table, write a SQL query to find the customers who belong to either the city ‘New York’ or not have a grade above 100. Return customer_id, cust_name, city, grade, and salesman_id.