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: Display the commission of all the salesmen servicing customers in Paris

SQL SUBQUERY : Exercise-6 with Solution

6. From the following tables write a SQL query to determine the commission of the salespeople in Paris. Return commission.

Sample table: Salesman


Sample table : Customer


Sample Solution: 

SELECT commission
FROM salesman
WHERE salesman_id IN
    (SELECT salesman_id 
     FROM customer
     WHERE city = 'Paris');

Output of the Query:

commission
0.14

Explanation:

SQL Subqueries: Display the commission of all the salesmen servicing customers in Paris.

Practice Online


Inventory database model

Query Visualization:

Duration:

Query visualization of Display the commission of all the salesmen servicing customers in Paris - Duration

Rows:

Query visualization of Display the commission of all the salesmen servicing customers in Paris - Rows

Cost:

Query visualization of Display the commission of all the salesmen servicing customers in Paris - Cost

Contribute your code and comments through Disqus.

Previous: From the following tables, write a SQL query to find all the orders generated in New York city. Return ord_no, purch_amt, ord_date, customer_id and salesman_id.
Next: Write a query to display all the customers whose id is 2001 bellow the salesman ID of Mc Lyon.

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