SQL: Locate the details of customers with grade values above 100

SQL Boolean Operators: Exercise-1 with Solution.

From the following table, write a SQL query to locate the details of customers with grade values above 100. Return customer_id, cust_name, city, grade, and salesman_id.

Sample table: customer

Sample Solution :

SELECT * 
FROM customer 
WHERE grade > 100;

Output of the Query:

customer_id	cust_name	city		grade	salesman_id
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: SQL Boolean and Relational Operators Exercises Home
Next: 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.