SQL Subquery Exercises: Find the customer whose id is 2001 bellow the salesman ID of Mc Lyon

Last update on June 04 2022 12:19:22 (UTC/GMT +8 hours)

SQL SUBQUERY: Exercise-7 with Solution

7. Write a query to display all the customers whose ID is 2001 below the salesperson ID of Mc Lyon.

Sample table : Customer

Sample table: Salesman

Sample Solution:

SELECT *
FROM customer
WHERE customer_id =
    (SELECT salesman_id -2001
     FROM salesman
     WHERE name = 'Mc Lyon');

Output of the Query:

customer_id	cust_name	city		grade	salesman_id
3005		Graham Zusi	California	200		5002

Explanation:

Duration:

Rows:

Cost:

Contribute your code and comments through Disqus.

Previous: From the following tables, write a SQL query to find the commission of the salespeople work in Paris City. Return commission.
Next: From the following tables, write a SQL query to count number of customers with grades above the average grades of New York City. Return grade and count.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

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