w3resource
SQL exercises

SQL Exercises: Find the customers along with the salesmen who works for them

SQL Query on Multiple Tables: Exercise-2 with Solution

Write a SQL statement to find the names of all customers along with the salesmen who works for them.

Sample table: customer


Sample table: salesman


Sample Solution:

SELECT customer.cust_name, salesman.name
FROM customer,salesman
WHERE salesman.salesman_id = customer.salesman_id;

Output of the query:

cust_name	name
Nick Rimando	James Hoog
Brad Davis	James Hoog
Graham Zusi	Nail Knite
Julian Green	Nail Knite
Fabian Johnson	Mc Lyon
Geoff Cameron	Lauson Hen
Jozy Altidor	Paul Adam
Brad Guzan	Pit Alex

Explanation:

Syntax to find the names of all customers along with the salesmen who works for them

Pictorial presentation:

Result of the names of all customers along with the salesmen who works for them

Query Visualization:

Duration:

Query visualization of Find the customers along with the salesmen who works for them - Duration

Rows:

Query visualization of Find the customers along with the salesmen who works for them - Rows

Cost:

Query visualization of Find the customers along with the salesmen who works for them - Cost

 

Practice Online


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

Previous: Write a query to find those customers with their name and those salesmen with their name and city who lives in the same city.
Next: Write a SQL statement to display all those orders by the customers not located in the same cities where their salesmen live.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming