SQL: Display all information using AND operator with specified conditions
SQL Boolean Operator Statement : Exercise-2 with Solution.
Write a query statement to display all customers in New York who have a grade value above 100.
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 s5001
Pictorial presentation :
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?