w3resource
SQL exercises

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


Explanation:

Syntax of all customers in New York

Pictorial presentation :

Result of all customers in New York

Query Visualization:

Duration:

Query visualization of Display all information using AND operator with specified conditions - Duration

Rows:

Query visualization of Display all information using AND operator with specified conditions - Rows

Cost:

Query visualization of Display all information using AND operator with specified conditions - Cost

 

Practice Online


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

Previous: Write a query to display all customers with a grade above 100.
Next: Write a SQL statement to display all customers, who are either belongs to the city New York or had a grade above 100.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming