SQL: Customers in ‘New York’ city who have a grade value above 100

SQL Boolean Operator Statement: Exercise-2 with Solution.

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.

Sample table: customer

Sample Solution:

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

Output of the Query:

customer_id	cust_name	city		grade		salesman_id
3007		Brad Davis	New York	200		5001


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 details of the customers who have a gradevalue 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 have a grade above 100. Return customer_id, cust_name, city, grade, and salesman_id.