From the following table, write a SQL query to find all those customers who does not have any grade. Return customer_id, cust_name, city

hamza

Save to bookmark

2022-05-18

140

From the following table, write a SQL query to find all those customers who does not have any grade. Return customer_id, cust_name, city, grade, 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

Sql programming,

All Answers

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

SELECT *
FROM customer
WHERE grade IS NULL;

Output of the Query:

customer_id	cust_name	city	grade	salesman_id
3001		Brad Guzan	London		5005

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

From the following table, write a SQL query to find all those customers who does not have any grade. Return customer_id, cust_name, city

All Answers

Similar questions

need a help?

find thousands of online teachers now