SQL Exercise: Information using AND operator with given conditions

Last update on February 10 2025 06:59:44 (UTC/GMT +8 hours)

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

 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
        3009 | Geoff Cameron  | Berlin     |   100 |        5003
        3003 | Jozy Altidor   | Moscow     |   200 |        5007
        3001 | Brad Guzan     | London     |       |        5005

Sample Solution:

 -- This query selects all columns from the 'customer' table.
SELECT *
-- Specifies the table from which to retrieve the data (in this case, 'customer').
FROM customer
-- Filters the rows to only include those where the 'city' column has the value 'New York'
-- and the 'grade' column has a value greater than 100.
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


Code Explanation:

The said SQL query that is selecting all columns (*) from the 'customer' table where the value of the "city" column is 'New York' and the value of the "grade" column is greater than 100. The query will return all rows from the "customer" table where the value in the "city" column is 'New York' and the value in the "grade" column is greater than 100.

Relational Algebra Expression:

Relational Algebra Tree:

Explanation:

Visual presentation :

Practice Online

For more Practice: Solve these Related Problems:

• Write a SQL query to find all customers from 'Paris' with a grade greater than 100.
• Write a SQL query to retrieve customers from 'California' whose grade is above 150.
• Write a SQL query to display customers from 'Berlin' with a grade exceeding 100, ordered by customer name.
• Write a SQL query to list customers from 'Moscow' with a grade greater than 200 and return their details.

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

Previous SQL Exercise: Display all information with specified conditions.
Next SQL Exercise: Information using OR operator with given conditions.