SQL Subquery Exercises: Display all the orders from the orders table issued by the salesman 'Paul Adam'.
SQL SUBQUERY: Exercise-1 with Solution
1. Write a query to display all the orders from the orders table issued by the salesman 'Paul Adam'.
Sample table: Salesman
Sample table: Orders
SELECT * FROM orders WHERE salesman_id = (SELECT salesman_id FROM salesman WHERE name='Paul Adam');
ord_no purch_amt ord_date customer_id salesman_id 70011 75.29 2012-08-17 3003 5007
Contribute your code and comments through Disqus.
What is the difficulty level of this exercise?