Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
w3resource

SQL Subquery Exercises: Get all information for those customers whose grade is not as grade of customer who belongs to the city London

SQL SUBQUERY: Exercise-28 with Solution

28. From the following tables write a SQL query to find those customers whose grades are not the same as those who live in London City. Return customer_id, cust_name, city, grade and salesman_id.

Sample table: Customer


Sample Solution: 

SELECT *
SELECT * FROM customer WHERE grade <> ALL 
(SELECT grade FROM customer WHERE city='London' AND NOT grade IS NULL);

Output of the Query:

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

Pictorial Presentation:

SQL Subqueries Inventory Exercises: Get all information for those customers whose grade is not as grade of customer who belongs to the city London.

Practice Online


HR database model

Query Visualization:

Duration:

Query visualization of Get all information for those customers whose grade is not as grade of customer who belongs to the city London - Duration

Rows:

Query visualization of Get all information for those customers whose grade is not as grade of customer who belongs to the city London - Rows

Cost:

Query visualization of Get all information for those customers whose grade is not as grade of customer who belongs to the city London - Cost

Contribute your code and comments through Disqus.

Previous: From the following tables, write a SQL query to calculate the total order amount generated by a salesman. The salesman should belong to the cities where any of the customer living. Return salesman name, city and total order amount.
Next: From the following tables, write a SQL query to find those customers whose grade are not same of those customers living in Paris. Return customer_id, cust_name, city, grade and salesman_id.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



SQL: Tips of the Day

SQL Server SELECT into existing table. 

INSERT INTO dbo.TABLETWO
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO
  (col1, col2)
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3