2. Importance of Subquery
3. Beginning Subquery - With Example I
5. Beginning Subquery - With Example II
7. Beginning Subquery - With Example III
9. Nested Subquery - SubQuery with LIKE
11. Nested Subquery - Mangers of Employee SubQueries
13. Nested Subquery - Employee Territories
15. Nested Subquery - CategoryName
17. Nested Subquery - Suppliers
19. Nested Subquery - Product Ordered
21. Nested Subquery - Employee Without Orders
23. Nested Subquery - Employees with same region
25. Nested Subquery - Territories not assigned to employee
27. Nested Subquery - Freight of orders
29. Nested Subquery - Supplied categories of seafood
31. Nested Subquery - customers in the same city
33. Nested Subquery - Employees with same manager
35. Nested Subquery - Products with reorderLevel
37. Nested Subquery - Supplier who live in Spain
39. Nested Subquery - Territories names Assigned to Employees
41. Nested Subquery - Products Supplied by Same Company
43. Nested Subquery - Customers who placed orders
45. Nested Subquery - Products never ordered
47. Nested Subquery - Territories never assign to Employees
49. Nested Subquery - Customers Who Never Placed Orders
51. Nested Subquery - Employees not assigned to Territories
53. Nested Subquery - Order Placed in 2008
55. Nested Subquery - Employees who have the same territories
57. Nested Subquery - Products ordered by customers
59. Nested Subquery - Employees Managed by Funk
61. Nested Subquery - Suppliers who supplied products to a customers
63. Nested Subquery - Customers who placed order more than 30
65. Nested Subquery - Employees with same territory
67. Nested Subquery - Customer Ordered Beverages Products
69. Nested Subquery - Suppliers for London Customers