Udemy - SQL & MySQL Subqueries Understanding the weird parts (3.2023)

Creation Time	Jan. 12, 2026, 9:59 a.m.
Last Access Time	Jan. 15, 2026, 2:16 p.m.
File Size	10.4 GB
Keywords	Subqueries SQL - Understanding 3 parts 2023 MySQL the Udemy weird
Total Requests	27
Total Files	805
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/29. Nested Subquery - Employee under managers who have managers.mp4 295.9 MB
8. In-Line View Subqueries Levelling Up Your SQL Skills/4. Inline View - Average Order Value Per Customer.mp4 258.3 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/12. CTE - Total and Average Sales.mp4 224.6 MB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/1. Question & Solution 1 - Join & Subquery.mp4 215.8 MB
1. Introduction to SQL Subquery/4. Beginning Subquery - With Example I.mp4 210.5 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/3. Nested Subquery - Mangers of Employee SubQueries.mp4 210.3 MB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/11. Question & Solution 6 - Join & Subquery.mp4 148.7 MB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/5. Question & Solution 3 - Join & Subquery.mp4 146.8 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/20. HAVING - Understanding Having for Join and Subquery.mp4 140.0 MB
8. In-Line View Subqueries Levelling Up Your SQL Skills/8. Inline View - Product Ordered By Largest Number of Customers.mp4 137.3 MB
3. Hands-On Exercise and Solutions Nested Subqueries/2. Solution - Product Never Order by Retails - Subquery.mp4 134.4 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/2. Introduction to Inner Join by Example.mp4 134.2 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/18. Inner Join - Quantity of Product, ProductName and Suppliers.mp4 131.2 MB
8. In-Line View Subqueries Levelling Up Your SQL Skills/10. Inline View - Top 10 By Quantity Sold.mp4 125.4 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/52. Solution - List of Customers, Products, Categories & Suppliers.mp4 121.1 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/37. Nested Subquery - Customers who placed orders.mp4 121.0 MB
1. Introduction to SQL Subquery/6. Beginning Subquery - With Example II.mp4 119.3 MB
1. Introduction to SQL Subquery/3. Importance of Subquery.mp4 116.5 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/1. Nested Subquery - SubQuery with LIKE.mp4 115.6 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/5. Nested Subquery - Employee Territories.mp4 110.9 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/4. CTE - Retrieve all Customers with Total Ordeer Amount.mp4 110.0 MB
8. In-Line View Subqueries Levelling Up Your SQL Skills/2. Inline View - Discount Amount for Products.mp4 107.2 MB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/4. Scalar Subquery - Employees who sold more than 100k.mp4 104.7 MB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/14. Multiple-Rows Subquery - More exercise and solution.mp4 104.6 MB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/10. Scalar Subquery - Orders of employees with fewest orders.mp4 102.5 MB
1. Introduction to SQL Subquery/8. Beginning Subquery - With Example III.mp4 101.9 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/14. CTE - TotalSales and RegionSales.mp4 100.6 MB
6. Single-Row Subqueries Single-Row Subqueries Demystified/2. Example 1 - Employee who has been with the company the longest.mp4 99.8 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/55. Nested Subquery - Suppliers who supplied products to a customers.mp4 99.6 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/2. CTE Subquery by Example.mp4 98.6 MB
8. In-Line View Subqueries Levelling Up Your SQL Skills/6. Inline View - Top 5 Customers By Total Orders.mp4 98.4 MB
3. Hands-On Exercise and Solutions Nested Subqueries/26. Solution - Supplier Who Supplied to Customer in WA Region & Cost Above 4000.mp4 97.2 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/8. Alias with Join.mp4 96.6 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/21. Nested Subquery - Supplied categories of seafood.mp4 96.2 MB
29. (Optional) Basic SQL Queries/15. Understanding WHERE (Filter).mp4 95.9 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/33. Nested Subquery - Territories names Assigned to Employees.mp4 95.7 MB
6. Single-Row Subqueries Single-Row Subqueries Demystified/12. Exmaple 6 - Most Expensive Products Per Category.mp4 91.6 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/58. Solution - Employees Who Managed More than 10 Orders.mp4 91.4 MB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/2. Scalar Subquery - Customers with Orders More than 20.mp4 91.3 MB
11. Correlated Subqueries A Must-Know Tool/1. Understanding Correlated Subquery I.mp4 90.4 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/61. Nested Subquery - Customer Ordered Beverages Products.mp4 89.3 MB
6. Single-Row Subqueries Single-Row Subqueries Demystified/10. Example 5 - Number of OrderID by Customer With Most Orders.mp4 87.7 MB
8. In-Line View Subqueries Levelling Up Your SQL Skills/1. Understanding Inline View Subquery.mp4 86.4 MB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/3. Question & Solution 2 - Join & Subquery.mp4 85.6 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/28. Suppliers, Products and Total Quantity.mp4 84.4 MB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/1. Understanding Multiple-Row Subquery.mp4 82.5 MB
6. Single-Row Subqueries Single-Row Subqueries Demystified/4. Example 2 - Customer Who Placed the latest Order.mp4 81.9 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/6. Indicating Source of Columns.mp4 80.7 MB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/19. Question & Solution 10 - Join & Subquery.mp4 77.9 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/12. Inner Join - ProductName, UnitPrice and SupplierName.mp4 77.1 MB
6. Single-Row Subqueries Single-Row Subqueries Demystified/1. Introduction to Single-Row Subquery.mp4 72.9 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/31. Nested Subquery - Supplier who live in Spain.mp4 72.1 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/7. Nested Subquery - CategoryName.mp4 72.0 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/49. Nested Subquery - Employees who have the same territories.mp4 71.9 MB
11. Correlated Subqueries A Must-Know Tool/5. Correlated Subquery - At one order in Beverages category.mp4 71.1 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/9. Nested Subquery - Suppliers.mp4 70.5 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/63. Nested Subquery - Suppliers for London Customers.mp4 69.9 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/47. Nested Subquery - Order Placed in 2008.mp4 68.9 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/27. Nested Subquery - Products with reorderLevel.mp4 67.7 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/10. CTE - Average unit price per category.mp4 67.0 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/1. Introduction to JOIN.mp4 66.0 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/24. Customers, Employee and Orders.mp4 65.2 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/53. Nested Subquery - Employees Managed by Funk.mp4 64.9 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/59. Nested Subquery - Employees with same territory.mp4 62.6 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/57. Nested Subquery - Customers who placed order more than 30.mp4 62.0 MB
3. Hands-On Exercise and Solutions Nested Subqueries/11. Solution - Customers who ordered beverages products.mp4 61.9 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/16. Inner Join - Product Name, Supplier and Category.mp4 60.6 MB
3. Hands-On Exercise and Solutions Nested Subqueries/14. Solution - Employees in Charge of Seattle.mp4 60.6 MB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/17. Question & Solution 9 - Join & Subquery.mp4 59.4 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/34. Solution - Join - Customer Purchased above 100 dollars.mp4 59.3 MB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/8. Scalar Subquery - Categories where average unit price greater than $30.mp4 59.2 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/14. Inner Join - ProductName and Categories.mp4 57.9 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/41. Nested Subquery - Territories never assign to Employees.mp4 57.8 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/35. Nested Subquery - Products Supplied by Same Company.mp4 57.6 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/25. Nested Subquery - Employees with same manager.mp4 57.1 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/15. Nested Subquery - Employees with same region.mp4 56.4 MB
11. Correlated Subqueries A Must-Know Tool/3. Understanding Correlated Subquery II.mp4 55.9 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/6. CTE - Product Sales Per Category.mp4 55.8 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/40. Solution - Customer, Supplier, Quantity and Total Price.mp4 55.7 MB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/15. Question & Solution 8 - Join & Subquery.mp4 55.5 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/26. Number of Orders per Employee Exercise with Solution.mp4 55.3 MB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/13. Question & Solution 7 - Join & Subquery.mp4 54.7 MB
3. Hands-On Exercise and Solutions Nested Subqueries/17. Solution - Products Ordered By Customers Who are Owners of Business.mp4 53.8 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/13. Nested Subquery - Employee Without Orders.mp4 53.5 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/23. Nested Subquery - customers in the same city.mp4 53.3 MB
3. Hands-On Exercise and Solutions Nested Subqueries/20. Solution - Products Ordered By Customers From Germany - Subquery.mp4 52.1 MB
3. Hands-On Exercise and Solutions Nested Subqueries/5. Solution - Category of Products Ordered in Germany.mp4 52.0 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/16. CTE - Top Five Customers.mp4 50.5 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/43. Solution - AveragePrice, Products and Customers.mp4 50.1 MB
29. (Optional) Basic SQL Queries/11. Distinct on multiple columns.mp4 50.0 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/43. Nested Subquery - Customers Who Never Placed Orders.mp4 49.5 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/22. HAVING - Understanding Having Example.mp4 49.2 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/11. Nested Subquery - Product Ordered.mp4 48.7 MB
6. Single-Row Subqueries Single-Row Subqueries Demystified/6. Example 3 - Product with highest unitPrice.mp4 48.5 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/61. Solution - Average UnitPrice, Supplier and Customers from France.mp4 47.6 MB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/7. Question & Solution 4 - Join & Subquery.mp4 47.3 MB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/2. Multiple-Rows Subquery - Products Ordered More Than 50 Times.mp4 47.2 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/22. CET - Top Five Products By Sales.mp4 47.0 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/19. Nested Subquery - Freight of orders.mp4 46.8 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/39. Nested Subquery - Products never ordered.mp4 45.6 MB
3. Hands-On Exercise and Solutions Nested Subqueries/8. Solution - Territories Assigned to Sale Rep Employees.mp4 45.0 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/10. USING with Join.mp4 44.8 MB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/6. Scalar Subquery - Orders shipped by the most recent Employee.mp4 44.7 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/20. CTE - Average Order Value.mp4 44.7 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/17. Nested Subquery - Territories not assigned to employee.mp4 44.7 MB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/9. Question & Solution 5 - Join & Subquery.mp4 44.7 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/8. CTE - Top Selling Products.mp4 43.4 MB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/1. Understanding Scalar Subquery.mp4 42.7 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/49. Solution - Total Quantity of Products for Customer and Supplier in Same Country.mp4 42.3 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/46. Solution - customers, products, supplier in Germany.mp4 41.9 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/31. Solution - Join - CategoryName and TotalQuantity.mp4 41.2 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/18. CTE - Discontinued Products.mp4 40.9 MB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/1. Introduction to CTE.mp4 40.6 MB
29. (Optional) Basic SQL Queries/13. Distinct on multiple columns II.mp4 39.4 MB
29. (Optional) Basic SQL Queries/17. Where and = by Example.mp4 38.1 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/51. Nested Subquery - Products ordered by customers.mp4 37.6 MB
3. Hands-On Exercise and Solutions Nested Subqueries/23. Solution - Supplier Who Supplied to Customer in WA Region - Subquery.mp4 37.5 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/57. Question - Employees Who Managed More than 10 Orders.mp4 37.4 MB
11. Correlated Subqueries A Must-Know Tool/9. Correlated Subquery - Products not ordered by customers from Germany.mp4 36.7 MB
11. Correlated Subqueries A Must-Know Tool/4. EXISTS for Correlated Subquery.mp4 34.6 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/37. Solution - Customers Who Ordered from a Specific Supplier.mp4 33.9 MB
29. (Optional) Basic SQL Queries/23. Where and By Example.mp4 33.6 MB
29. (Optional) Basic SQL Queries/9. How to use DISTINCT.mp4 33.0 MB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/12. Multiple-Rows Subquery - Products that have UnitPrice greater than its category.mp4 32.9 MB
11. Correlated Subqueries A Must-Know Tool/13. Correlated Subquery - More Exercise with Solution.mp4 32.4 MB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/45. Nested Subquery - Employees not assigned to Territories.mp4 32.1 MB
6. Single-Row Subqueries Single-Row Subqueries Demystified/8. Example 4 - Order with Highest Freight Value.mp4 31.2 MB
29. (Optional) Basic SQL Queries/5. Selecting Multiple columns.mp4 29.8 MB
11. Correlated Subqueries A Must-Know Tool/7. Correlated Subquery - Customers who have not placed any order in condiments.mp4 29.2 MB
29. (Optional) Basic SQL Queries/3. Selecting a Specific Column.mp4 29.2 MB
3. Hands-On Exercise and Solutions Nested Subqueries/29. Solution - Customers Ordered UK Suppliers Products.mp4 28.8 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/30. Question - Join - CategoryName and TotalQuantity.mp4 26.1 MB
29. (Optional) Basic SQL Queries/19. Where and By Example.mp4 25.4 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/36. Question - Customers Who Ordered from a Specific Supplier.mp4 23.1 MB
29. (Optional) Basic SQL Queries/1. Selecting all columns.mp4 23.0 MB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/10. Multiple-Rows Subquery - Suppliers with product more than 100.mp4 21.8 MB
29. (Optional) Basic SQL Queries/7. Selecting Multiple columns II.mp4 20.3 MB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/4. Multiple-Rows Subquery - Customers who placed orders in 2008.mp4 20.2 MB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/8. Multiple-Rows Subquery -Categories with at least 10 products.mp4 19.6 MB
29. (Optional) Basic SQL Queries/21. Where and != By Example.mp4 18.8 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/55. Solution - Employees and a Specific Supplier.mp4 18.5 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/48. Question - Total Quantity of Products for Customer and Supplier in Same Country.mp4 18.1 MB
11. Correlated Subqueries A Must-Know Tool/11. Correlated Subquery - Customers Placed Orders for Discontinued products.mp4 18.1 MB
3. Hands-On Exercise and Solutions Nested Subqueries/4. Question - Category of Products Ordered in Germany.mp4 17.1 MB
29. (Optional) Basic SQL Queries/25. Where and = By Example.mp4 15.3 MB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/6. Multiple-Rows Subquery - Employees that have made at least one sales.mp4 15.1 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/67. Final Join Solution.mp4 13.7 MB
3. Hands-On Exercise and Solutions Nested Subqueries/1. Question - Product Never Order by Retails - Subquery.mp4 13.6 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/69. NEXT.mp4 13.1 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/33. Question - Join - Customer Purchased above 100 dollars.mp4 12.2 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/4. Rearranging your query.mp4 11.7 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/63. Question - Total Quantity of Product, Suppliers sold more than 1200 units.mp4 10.9 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/54. Question - Employees and a Specific Supplier.mp4 10.7 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/66. Final Join Question.mp4 10.5 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/45. Question - customers, products, supplier in Germany.mp4 10.3 MB
3. Hands-On Exercise and Solutions Nested Subqueries/25. Question - Supplier Who Supplied to Customer in WA Region & Cost Above 4000.mp4 10.1 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/42. Question - AveragePrice, Products and Customers.mp4 10.0 MB
3. Hands-On Exercise and Solutions Nested Subqueries/7. Question - Territories Assigned to Sale Rep Employees.mp4 7.5 MB
29. (Optional) Basic SQL Queries/29. Where and = By Example.mp4 7.1 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/51. Question - List of Customers, Products, Categories & Suppliers.mp4 6.9 MB
3. Hands-On Exercise and Solutions Nested Subqueries/22. Question - Supplier Who Supplied to Customer in WA Region - Subquery.mp4 6.8 MB
3. Hands-On Exercise and Solutions Nested Subqueries/19. Question - Products Ordered By Customers From Germany - Subquery.mp4 6.8 MB
3. Hands-On Exercise and Solutions Nested Subqueries/16. Question - Products Ordered By Customers Who are Owners of Business.mp4 6.7 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/64. Solution - Total Quantity of Product, Suppliers sold more than 1200 units.mp4 5.7 MB
3. Hands-On Exercise and Solutions Nested Subqueries/28. Question - Customers Ordered UK Suppliers Products.mp4 5.3 MB
29. (Optional) Basic SQL Queries/27. Where and By Example.mp4 5.3 MB
3. Hands-On Exercise and Solutions Nested Subqueries/13. Question - Employees in Charge of Seattle.mp4 5.1 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/60. Question - Average UnitPrice, Supplier and Customers from France.mp4 4.7 MB
3. Hands-On Exercise and Solutions Nested Subqueries/10. Question - Customers who ordered beverages products.mp4 4.5 MB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/39. Question - Customer, Supplier, Quantity and Total Price.mp4 4.2 MB
12. For Questions and Answers Read Me Please!/1.2 2. sakila-data-Insert.sql 3.2 MB
1. Introduction to SQL Subquery/2.1 1 Database_Tables_Dataset.original 606.7 KB
12. For Questions and Answers Read Me Please!/1.3 3 schema_picture.png 227.1 KB
1. Introduction to SQL Subquery/2.2 northwind-er-relationship.png 164.6 KB
12. For Questions and Answers Read Me Please!/1.1 1. sakila-schema-createTable.sql 23.7 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/29. Nested Subquery - Employee under managers who have managers.srt 16.6 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/12. CTE - Total and Average Sales.srt 14.3 KB
8. In-Line View Subqueries Levelling Up Your SQL Skills/4. Inline View - Average Order Value Per Customer.srt 13.2 KB
1. Introduction to SQL Subquery/4. Beginning Subquery - With Example I.srt 12.6 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/3. Nested Subquery - Mangers of Employee SubQueries.srt 12.6 KB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/1. Question & Solution 1 - Join & Subquery.srt 11.6 KB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/11. Question & Solution 6 - Join & Subquery.srt 11.4 KB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/5. Question & Solution 3 - Join & Subquery.srt 11.1 KB
3. Hands-On Exercise and Solutions Nested Subqueries/2. Solution - Product Never Order by Retails - Subquery.srt 8.9 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/18. Inner Join - Quantity of Product, ProductName and Suppliers.srt 8.6 KB
1. Introduction to SQL Subquery/6. Beginning Subquery - With Example II.srt 8.2 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/52. Solution - List of Customers, Products, Categories & Suppliers.srt 8.2 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/20. HAVING - Understanding Having for Join and Subquery.srt 7.9 KB
8. In-Line View Subqueries Levelling Up Your SQL Skills/8. Inline View - Product Ordered By Largest Number of Customers.srt 7.9 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/2. Introduction to Inner Join by Example.srt 7.6 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/31. Nested Subquery - Supplier who live in Spain.srt 7.6 KB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/10. Scalar Subquery - Orders of employees with fewest orders.srt 7.3 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/1. Nested Subquery - SubQuery with LIKE.srt 6.9 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/8. Alias with Join.srt 6.9 KB
8. In-Line View Subqueries Levelling Up Your SQL Skills/10. Inline View - Top 10 By Quantity Sold.srt 6.6 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/58. Solution - Employees Who Managed More than 10 Orders.srt 6.6 KB
8. In-Line View Subqueries Levelling Up Your SQL Skills/2. Inline View - Discount Amount for Products.srt 6.5 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/5. Nested Subquery - Employee Territories.srt 6.4 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/37. Nested Subquery - Customers who placed orders.srt 6.4 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/4. CTE - Retrieve all Customers with Total Ordeer Amount.srt 6.3 KB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/4. Scalar Subquery - Employees who sold more than 100k.srt 6.3 KB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/3. Question & Solution 2 - Join & Subquery.srt 6.2 KB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/14. Multiple-Rows Subquery - More exercise and solution.srt 6.2 KB
1. Introduction to SQL Subquery/8. Beginning Subquery - With Example III.srt 6.1 KB
1. Introduction to SQL Subquery/3. Importance of Subquery.srt 6.1 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/14. CTE - TotalSales and RegionSales.srt 5.9 KB
8. In-Line View Subqueries Levelling Up Your SQL Skills/6. Inline View - Top 5 Customers By Total Orders.srt 5.8 KB
6. Single-Row Subqueries Single-Row Subqueries Demystified/10. Example 5 - Number of OrderID by Customer With Most Orders.srt 5.8 KB
6. Single-Row Subqueries Single-Row Subqueries Demystified/2. Example 1 - Employee who has been with the company the longest.srt 5.8 KB
3. Hands-On Exercise and Solutions Nested Subqueries/26. Solution - Supplier Who Supplied to Customer in WA Region & Cost Above 4000.srt 5.7 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/28. Suppliers, Products and Total Quantity.srt 5.7 KB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/19. Question & Solution 10 - Join & Subquery.srt 5.5 KB
6. Single-Row Subqueries Single-Row Subqueries Demystified/12. Exmaple 6 - Most Expensive Products Per Category.srt 5.5 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/21. Nested Subquery - Supplied categories of seafood.srt 5.5 KB
6. Single-Row Subqueries Single-Row Subqueries Demystified/4. Example 2 - Customer Who Placed the latest Order.srt 5.3 KB
29. (Optional) Basic SQL Queries/15. Understanding WHERE (Filter).srt 5.3 KB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/2. Scalar Subquery - Customers with Orders More than 20.srt 5.1 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/27. Nested Subquery - Products with reorderLevel.srt 5.0 KB
11. Correlated Subqueries A Must-Know Tool/1. Understanding Correlated Subquery I.srt 4.9 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/6. Indicating Source of Columns.srt 4.9 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/2. CTE Subquery by Example.srt 4.8 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/55. Nested Subquery - Suppliers who supplied products to a customers.srt 4.7 KB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/1. Understanding Multiple-Row Subquery.srt 4.4 KB
11. Correlated Subqueries A Must-Know Tool/5. Correlated Subquery - At one order in Beverages category.srt 4.4 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/12. Inner Join - ProductName, UnitPrice and SupplierName.srt 4.4 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/25. Nested Subquery - Employees with same manager.srt 4.3 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/33. Nested Subquery - Territories names Assigned to Employees.srt 4.3 KB
8. In-Line View Subqueries Levelling Up Your SQL Skills/1. Understanding Inline View Subquery.srt 4.3 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/14. Inner Join - ProductName and Categories.srt 4.2 KB
3. Hands-On Exercise and Solutions Nested Subqueries/14. Solution - Employees in Charge of Seattle.srt 4.2 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/9. Nested Subquery - Suppliers.srt 4.1 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/34. Solution - Join - Customer Purchased above 100 dollars.srt 4.1 KB
6. Single-Row Subqueries Single-Row Subqueries Demystified/1. Introduction to Single-Row Subquery.srt 4.0 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/1. Introduction to JOIN.srt 4.0 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/10. CTE - Average unit price per category.srt 4.0 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/24. Customers, Employee and Orders.srt 3.8 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/7. Nested Subquery - CategoryName.srt 3.7 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/47. Nested Subquery - Order Placed in 2008.srt 3.7 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/43. Solution - AveragePrice, Products and Customers.srt 3.7 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/23. Nested Subquery - customers in the same city.srt 3.6 KB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/17. Question & Solution 9 - Join & Subquery.srt 3.5 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/13. Nested Subquery - Employee Without Orders.srt 3.5 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/22. HAVING - Understanding Having Example.srt 3.5 KB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/8. Scalar Subquery - Categories where average unit price greater than $30.srt 3.5 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/49. Nested Subquery - Employees who have the same territories.srt 3.5 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/41. Nested Subquery - Territories never assign to Employees.srt 3.5 KB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/15. Question & Solution 8 - Join & Subquery.srt 3.5 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/61. Nested Subquery - Customer Ordered Beverages Products.srt 3.5 KB
3. Hands-On Exercise and Solutions Nested Subqueries/12. CODE - Customers who ordered beverages products.html 3.4 KB
11. Correlated Subqueries A Must-Know Tool/3. Understanding Correlated Subquery II.srt 3.4 KB
3. Hands-On Exercise and Solutions Nested Subqueries/30. CODE - Customers Ordered UK Suppliers Products.html 3.4 KB
3. Hands-On Exercise and Solutions Nested Subqueries/24. CODE - Supplier Who Supplied to Customer in WA Region - Subquery.html 3.4 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/40. Solution - Customer, Supplier, Quantity and Total Price.srt 3.4 KB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/13. Question & Solution 7 - Join & Subquery.srt 3.4 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/15. Nested Subquery - Employees with same region.srt 3.4 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/61. Solution - Average UnitPrice, Supplier and Customers from France.srt 3.4 KB
3. Hands-On Exercise and Solutions Nested Subqueries/11. Solution - Customers who ordered beverages products.srt 3.3 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/26. Number of Orders per Employee Exercise with Solution.srt 3.3 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/20. CTE - Average Order Value.srt 3.2 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/16. Inner Join - Product Name, Supplier and Category.srt 3.2 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/16. CTE - Top Five Customers.srt 3.2 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/49. Solution - Total Quantity of Products for Customer and Supplier in Same Country.srt 3.2 KB
29. (Optional) Basic SQL Queries/11. Distinct on multiple columns.srt 3.1 KB
3. Hands-On Exercise and Solutions Nested Subqueries/8. Solution - Territories Assigned to Sale Rep Employees.srt 3.1 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/11. Nested Subquery - Product Ordered.srt 3.0 KB
6. Single-Row Subqueries Single-Row Subqueries Demystified/6. Example 3 - Product with highest unitPrice.srt 3.0 KB
3. Hands-On Exercise and Solutions Nested Subqueries/5. Solution - Category of Products Ordered in Germany.srt 3.0 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/6. CTE - Product Sales Per Category.srt 3.0 KB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/9. Question & Solution 5 - Join & Subquery.srt 3.0 KB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/7. Question & Solution 4 - Join & Subquery.srt 2.9 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/35. Nested Subquery - Products Supplied by Same Company.srt 2.9 KB
3. Hands-On Exercise and Solutions Nested Subqueries/20. Solution - Products Ordered By Customers From Germany - Subquery.srt 2.9 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/46. Solution - customers, products, supplier in Germany.srt 2.9 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/22. CET - Top Five Products By Sales.srt 2.9 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/53. Nested Subquery - Employees Managed by Funk.srt 2.8 KB
3. Hands-On Exercise and Solutions Nested Subqueries/27. CODE - Supplier Who Supplied to Customer in WA Region & Cost Above 4000.html 2.8 KB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/6. Scalar Subquery - Orders shipped by the most recent Employee.srt 2.8 KB
3. Hands-On Exercise and Solutions Nested Subqueries/17. Solution - Products Ordered By Customers Who are Owners of Business.srt 2.8 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/18. CTE - Discontinued Products.srt 2.7 KB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/2. Multiple-Rows Subquery - Products Ordered More Than 50 Times.srt 2.7 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/8. CTE - Top Selling Products.srt 2.7 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/17. Nested Subquery - Territories not assigned to employee.srt 2.7 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/39. Nested Subquery - Products never ordered.srt 2.6 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/31. Solution - Join - CategoryName and TotalQuantity.srt 2.6 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/37. Solution - Customers Who Ordered from a Specific Supplier.srt 2.6 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/10. USING with Join.srt 2.6 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/43. Nested Subquery - Customers Who Never Placed Orders.srt 2.5 KB
29. (Optional) Basic SQL Queries/13. Distinct on multiple columns II.srt 2.4 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/19. Nested Subquery - Freight of orders.srt 2.4 KB
11. Correlated Subqueries A Must-Know Tool/9. Correlated Subquery - Products not ordered by customers from Germany.srt 2.3 KB
3. Hands-On Exercise and Solutions Nested Subqueries/23. Solution - Supplier Who Supplied to Customer in WA Region - Subquery.srt 2.2 KB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/12. Multiple-Rows Subquery - Products that have UnitPrice greater than its category.srt 2.2 KB
11. Correlated Subqueries A Must-Know Tool/13. Correlated Subquery - More Exercise with Solution.srt 2.2 KB
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/1. Understanding Scalar Subquery.srt 2.2 KB
29. (Optional) Basic SQL Queries/17. Where and = by Example.srt 2.2 KB
29. (Optional) Basic SQL Queries/23. Where and By Example.srt 2.1 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/57. Nested Subquery - Customers who placed order more than 30.srt 2.1 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/57. Question - Employees Who Managed More than 10 Orders.srt 2.1 KB
3. Hands-On Exercise and Solutions Nested Subqueries/3. CODE - Product Never Order by Retails - Subquery.html 2.0 KB
11. Correlated Subqueries A Must-Know Tool/7. Correlated Subquery - Customers who have not placed any order in condiments.srt 2.0 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/63. Nested Subquery - Suppliers for London Customers.srt 2.0 KB
28. Subqueries - Questions and Answers 151 to 160/2. Answer 151.html 2.0 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/1. Introduction to CTE.srt 2.0 KB
3. Hands-On Exercise and Solutions Nested Subqueries/6. CODE - Category of Products Ordered in Germany.html 2.0 KB
12. For Questions and Answers Read Me Please!/1. A brief Introduction.html 2.0 KB
11. Correlated Subqueries A Must-Know Tool/4. EXISTS for Correlated Subquery.srt 1.9 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/59. Nested Subquery - Employees with same territory.srt 1.9 KB
6. Single-Row Subqueries Single-Row Subqueries Demystified/8. Example 4 - Order with Highest Freight Value.srt 1.8 KB
29. (Optional) Basic SQL Queries/5. Selecting Multiple columns.srt 1.8 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/55. Solution - Employees and a Specific Supplier.srt 1.8 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/51. Nested Subquery - Products ordered by customers.srt 1.8 KB
28. Subqueries - Questions and Answers 151 to 160/8. Answer 154.html 1.8 KB
3. Hands-On Exercise and Solutions Nested Subqueries/29. Solution - Customers Ordered UK Suppliers Products.srt 1.7 KB
29. (Optional) Basic SQL Queries/3. Selecting a Specific Column.srt 1.7 KB
29. (Optional) Basic SQL Queries/9. How to use DISTINCT.srt 1.7 KB
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/45. Nested Subquery - Employees not assigned to Territories.srt 1.7 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/30. Question - Join - CategoryName and TotalQuantity.srt 1.7 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/36. Question - Customers Who Ordered from a Specific Supplier.srt 1.6 KB
29. (Optional) Basic SQL Queries/19. Where and By Example.srt 1.6 KB
27. Subqueries - Questions and Answers 141 to 150/14. Answer 147.html 1.6 KB
28. Subqueries - Questions and Answers 151 to 160/18. Answer 159.html 1.4 KB
3. Hands-On Exercise and Solutions Nested Subqueries/21. CODE - Products Ordered By Customers From Germany - Subquery.html 1.4 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/15. CODE CTE - TotalSales and RegionSales.html 1.4 KB
28. Subqueries - Questions and Answers 151 to 160/10. Answer 155.html 1.4 KB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/10. Multiple-Rows Subquery - Suppliers with product more than 100.srt 1.4 KB
3. Hands-On Exercise and Solutions Nested Subqueries/9. CODE - Territories Assigned to Sale Rep Employees.html 1.4 KB
3. Hands-On Exercise and Solutions Nested Subqueries/15. CODE - Employees in Charge of Seattle.html 1.3 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/67. Final Join Solution.srt 1.3 KB
3. Hands-On Exercise and Solutions Nested Subqueries/18. CODE - Products Ordered By Customers Who are Owners of Business.html 1.3 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/48. Question - Total Quantity of Products for Customer and Supplier in Same Country.srt 1.3 KB
29. (Optional) Basic SQL Queries/1. Selecting all columns.srt 1.3 KB
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/4. Rearranging your query.srt 1.3 KB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/8. Multiple-Rows Subquery -Categories with at least 10 products.srt 1.3 KB
29. (Optional) Basic SQL Queries/21. Where and != By Example.srt 1.2 KB
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/20. CODE Question & Solution 10 - Join & Subquery.html 1.2 KB
27. Subqueries - Questions and Answers 141 to 150/18. Answer 149.html 1.2 KB
21. Subqueries - Questions and Answers 81 to 90/14. Answer 87.html 1.2 KB
1. Introduction to SQL Subquery/1. You are welcome!.html 1.2 KB
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/4. Multiple-Rows Subquery - Customers who placed orders in 2008.srt 1.2 KB
21. Subqueries - Questions and Answers 81 to 90/16. Answer 88.html 1.1 KB
29. (Optional) Basic SQL Queries/7. Selecting Multiple columns II.srt 1.1 KB
28. Subqueries - Questions and Answers 151 to 160/14. Answer 157.html 1.1 KB
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/13. CODE CTE - Total and Average Sales.html 1.1 KB
28. Subqueries - Questions and Answers 151 to 160/12. Answer 156.html 1.1 KB
21. Subqueries - Questions and Answers 81 to 90/18. Answer 89.html 1.0 KB
11. Correlated Subqueries A Must-Know Tool/11. Correlated Subquery - Customers Placed Orders for Discontinued products.srt 1.0 KB
29. (Optional) Basic SQL Queries/25. Where and = By Example.srt 999 bytes
3. Hands-On Exercise and Solutions Nested Subqueries/4. Question - Category of Products Ordered in Germany.srt 996 bytes
27. Subqueries - Questions and Answers 141 to 150/6. Answer 143.html 984 bytes
28. Subqueries - Questions and Answers 151 to 160/16. Answer 158.html 981 bytes
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/5. CODE CTE - Retrieve all Customers with Total Ordeer Amount.html 979 bytes
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/6. Multiple-Rows Subquery - Employees that have made at least one sales.srt 973 bytes
27. Subqueries - Questions and Answers 141 to 150/8. Answer 144.html 967 bytes
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/12. CODE Question & Solution 6 - Join & Subquery.html 967 bytes
3. Hands-On Exercise and Solutions Nested Subqueries/1. Question - Product Never Order by Retails - Subquery.srt 960 bytes
27. Subqueries - Questions and Answers 141 to 150/20. Answer 150.html 937 bytes
27. Subqueries - Questions and Answers 141 to 150/12. Answer 146.html 933 bytes
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/11. CODE CTE - Average unit price per category.html 910 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/54. Question - Employees and a Specific Supplier.srt 891 bytes
19. Subqueries - Questions and Answers 61 to 70/18. Answer 69.html 873 bytes
1. Introduction to SQL Subquery/2. Database (Datasets) for the course.html 843 bytes
22. Subqueries - Questions and Answers 91 to 100/10. Answer 95.html 843 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/33. Question - Join - Customer Purchased above 100 dollars.srt 833 bytes
25. Subqueries - Questions and Answers 121 to 130/12. Answer 126.html 829 bytes
24. Subqueries - Questions and Answers 111 to 120/10. Answer 115.html 825 bytes
18. Subqueries - Questions and Answers 51 to 60/2. Answer 51.html 818 bytes
23. Subqueries - Questions and Answers 101 to 110/6. Answer 103.html 812 bytes
27. Subqueries - Questions and Answers 141 to 150/4. Answer 142.html 798 bytes
17. Subqueries - Questions and Answers 41 to 50/20. Answer 50.html 788 bytes
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/2. CODE Question & Solution 1 - Join & Subquery.html 788 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/42. Question - AveragePrice, Products and Customers.srt 783 bytes
19. Subqueries - Questions and Answers 61 to 70/4. Answer 62.html 777 bytes
26. Subqueries - Questions and Answers 131 to 140/2. Answer 131.html 770 bytes
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/23. CODE CET - Top Five Products By Sales.html 766 bytes
21. Subqueries - Questions and Answers 81 to 90/12. Answer 86.html 757 bytes
28. Subqueries - Questions and Answers 151 to 160/20. Answer 160.html 757 bytes
26. Subqueries - Questions and Answers 131 to 140/8. Answer 134.html 751 bytes
19. Subqueries - Questions and Answers 61 to 70/2. Answer 61.html 750 bytes
28. Subqueries - Questions and Answers 151 to 160/4. Answer 152.html 745 bytes
24. Subqueries - Questions and Answers 111 to 120/6. Answer 113.html 741 bytes
27. Subqueries - Questions and Answers 141 to 150/10. Answer 145.html 740 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/45. Question - customers, products, supplier in Germany.srt 737 bytes
28. Subqueries - Questions and Answers 151 to 160/6. Answer 153.html 732 bytes
24. Subqueries - Questions and Answers 111 to 120/18. Answer 119.html 722 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/13. CODE Inner Join - ProductName, UnitPrice and SupplierName.html 718 bytes
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/6. CODE Question & Solution 3 - Join & Subquery.html 718 bytes
29. (Optional) Basic SQL Queries/29. Where and = By Example.srt 715 bytes
24. Subqueries - Questions and Answers 111 to 120/8. Answer 114.html 712 bytes
27. Subqueries - Questions and Answers 141 to 150/16. Answer 148.html 712 bytes
15. Subqueries - Questions and Answers 21 to 30/12. Answer 26.html 711 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/69. NEXT.srt 708 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/62. CODE Nested Subquery - Customer Ordered Beverages Products.html 686 bytes
24. Subqueries - Questions and Answers 111 to 120/16. Answer 118.html 684 bytes
26. Subqueries - Questions and Answers 131 to 140/12. Answer 136.html 681 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/56. CODE Nested Subquery - Suppliers who supplied products to a customers.html 679 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/66. Final Join Question.srt 678 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/64. Solution - Total Quantity of Product, Suppliers sold more than 1200 units.srt 675 bytes
24. Subqueries - Questions and Answers 111 to 120/12. Answer 116.html 668 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/64. CODE Nested Subquery - Suppliers for London Customers.html 667 bytes
25. Subqueries - Questions and Answers 121 to 130/20. Answer 130.html 655 bytes
25. Subqueries - Questions and Answers 121 to 130/18. Answer 129.html 643 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/63. Question - Total Quantity of Product, Suppliers sold more than 1200 units.srt 637 bytes
26. Subqueries - Questions and Answers 131 to 140/10. Answer 135.html 636 bytes
19. Subqueries - Questions and Answers 61 to 70/20. Answer 70.html 634 bytes
24. Subqueries - Questions and Answers 111 to 120/20. Answer 120.html 629 bytes
26. Subqueries - Questions and Answers 131 to 140/20. Answer 140.html 621 bytes
26. Subqueries - Questions and Answers 131 to 140/16. Answer 138.html 620 bytes
24. Subqueries - Questions and Answers 111 to 120/14. Answer 117.html 614 bytes
20. Subqueries - Questions and Answers 71 to 80/10. Answer 75.html 610 bytes
26. Subqueries - Questions and Answers 131 to 140/18. Answer 139.html 610 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/15. CODE Inner Join - ProductName and Categories.html 604 bytes
15. Subqueries - Questions and Answers 21 to 30/16. Answer 28.html 603 bytes
21. Subqueries - Questions and Answers 81 to 90/20. Answer 90.html 600 bytes
26. Subqueries - Questions and Answers 131 to 140/6. Answer 133.html 598 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/50. CODE Solution - Total Quantity of Products for Customer and Supplier in Same C.html 598 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/9. CODE Alias with Join.html 598 bytes
23. Subqueries - Questions and Answers 101 to 110/18. Answer 109.html 591 bytes
23. Subqueries - Questions and Answers 101 to 110/14. Answer 107.html 589 bytes
27. Subqueries - Questions and Answers 141 to 150/2. Answer 141.html 584 bytes
13. Subqueries - Questions and Answers 1 to 10/16. Answer 8.html 577 bytes
15. Subqueries - Questions and Answers 21 to 30/18. Answer 29.html 577 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/59. CODE Solution - Employees Who Managed More than 10 Orders.html 571 bytes
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/4. CODE Question & Solution 2 - Join & Subquery.html 571 bytes
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/17. CODE CTE - Top Five Customers.html 570 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/60. CODE Nested Subquery - Employees with same territory.html 568 bytes
15. Subqueries - Questions and Answers 21 to 30/2. Answer 21.html 567 bytes
22. Subqueries - Questions and Answers 91 to 100/16. Answer 98.html 564 bytes
14. Subqueries - Questions and Answers 11 to 20/20. Answer 20.html 563 bytes
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/14. CODE Question & Solution 7 - Join & Subquery.html 563 bytes
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/21. CODE CTE - Average Order Value.html 560 bytes
6. Single-Row Subqueries Single-Row Subqueries Demystified/11. CODE Example 5 - Number of OrderID by Customer With Most Orders.html 559 bytes
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/19. CODE CTE - Discontinued Products.html 559 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/62. CODE Solution - Average UnitPrice, Supplier and Customers from France.html 556 bytes
21. Subqueries - Questions and Answers 81 to 90/2. Answer 81.html 553 bytes
23. Subqueries - Questions and Answers 101 to 110/2. Answer 101.html 553 bytes
15. Subqueries - Questions and Answers 21 to 30/20. Answer 30.html 552 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/68. CODE Final Join Solution.html 548 bytes
8. In-Line View Subqueries Levelling Up Your SQL Skills/5. CODE Inline View - Average Order Value Per Customer.html 543 bytes
20. Subqueries - Questions and Answers 71 to 80/16. Answer 78.html 541 bytes
25. Subqueries - Questions and Answers 121 to 130/6. Answer 123.html 540 bytes
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/16. CODE Question & Solution 8 - Join & Subquery.html 540 bytes
19. Subqueries - Questions and Answers 61 to 70/16. Answer 68.html 536 bytes
26. Subqueries - Questions and Answers 131 to 140/14. Answer 137.html 536 bytes
25. Subqueries - Questions and Answers 121 to 130/4. Answer 122.html 533 bytes
3. Hands-On Exercise and Solutions Nested Subqueries/19. Question - Products Ordered By Customers From Germany - Subquery.srt 524 bytes
25. Subqueries - Questions and Answers 121 to 130/8. Answer 124.html 523 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/41. CODE Solution - Customer, Supplier, Quantity and Total Price.html 522 bytes
22. Subqueries - Questions and Answers 91 to 100/20. Answer 100.html 519 bytes
25. Subqueries - Questions and Answers 121 to 130/2. Answer 121.html 517 bytes
3. Hands-On Exercise and Solutions Nested Subqueries/25. Question - Supplier Who Supplied to Customer in WA Region & Cost Above 4000.srt 517 bytes
22. Subqueries - Questions and Answers 91 to 100/6. Answer 93.html 512 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/58. CODE Nested Subquery - Customers who placed order more than 30.html 511 bytes
3. Hands-On Exercise and Solutions Nested Subqueries/16. Question - Products Ordered By Customers Who are Owners of Business.srt 510 bytes
25. Subqueries - Questions and Answers 121 to 130/16. Answer 128.html 505 bytes
3. Hands-On Exercise and Solutions Nested Subqueries/22. Question - Supplier Who Supplied to Customer in WA Region - Subquery.srt 504 bytes
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/7. CODE CTE - Product Sales Per Category.html 504 bytes
13. Subqueries - Questions and Answers 1 to 10/18. Answer 9.html 502 bytes
22. Subqueries - Questions and Answers 91 to 100/14. Answer 97.html 501 bytes
24. Subqueries - Questions and Answers 111 to 120/2. Answer 111.html 499 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/53. CODE Solution - List of Customers, Products, Categories & Suppliers.html 497 bytes
24. Subqueries - Questions and Answers 111 to 120/4. Answer 112.html 485 bytes
22. Subqueries - Questions and Answers 91 to 100/8. Answer 94.html 477 bytes
25. Subqueries - Questions and Answers 121 to 130/14. Answer 127.html 477 bytes
3. Hands-On Exercise and Solutions Nested Subqueries/7. Question - Territories Assigned to Sale Rep Employees.srt 475 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/21. CODE HAVING - Understanding Having for Join and Subquery.html 473 bytes
19. Subqueries - Questions and Answers 61 to 70/8. Answer 64.html 471 bytes
13. Subqueries - Questions and Answers 1 to 10/6. Answer 3.html 468 bytes
16. Subqueries - Questions and Answers 31 to 40/18. Answer 39.html 468 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/51. Question - List of Customers, Products, Categories & Suppliers.srt 466 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/47. CODE Solution - customers, products, supplier in Germany.html 465 bytes
13. Subqueries - Questions and Answers 1 to 10/4. Answer 2.html 462 bytes
20. Subqueries - Questions and Answers 71 to 80/2. Answer 71.html 462 bytes
16. Subqueries - Questions and Answers 31 to 40/16. Answer 38.html 461 bytes
22. Subqueries - Questions and Answers 91 to 100/4. Answer 92.html 460 bytes
20. Subqueries - Questions and Answers 71 to 80/12. Answer 76.html 458 bytes
8. In-Line View Subqueries Levelling Up Your SQL Skills/9. CODE Inline View - Product Ordered By Largest Number of Customers.html 452 bytes
18. Subqueries - Questions and Answers 51 to 60/4. Answer 52.html 448 bytes
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/15. CODE Multiple-Rows Subquery - More exercise and solution.html 442 bytes
23. Subqueries - Questions and Answers 101 to 110/16. Answer 108.html 436 bytes
19. Subqueries - Questions and Answers 61 to 70/12. Answer 66.html 434 bytes
1. Introduction to SQL Subquery/7. CODE Beginning Subquery - With Example II.html 430 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/56. CODE Solution - Employees and a Specific Supplier.html 428 bytes
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/18. CODE Question & Solution 9 - Join & Subquery.html 428 bytes
8. In-Line View Subqueries Levelling Up Your SQL Skills/3. CODE Inline View - Discount Amount for Products.html 428 bytes
23. Subqueries - Questions and Answers 101 to 110/4. Answer 102.html 427 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/65. CODE Solution - Total Quantity of Product, Suppliers sold more than 1200 units.html 427 bytes
16. Subqueries - Questions and Answers 31 to 40/20. Answer 40.html 425 bytes
23. Subqueries - Questions and Answers 101 to 110/20. Answer 110.html 421 bytes
20. Subqueries - Questions and Answers 71 to 80/14. Answer 77.html 420 bytes
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/8. CODE Question & Solution 4 - Join & Subquery.html 420 bytes
20. Subqueries - Questions and Answers 71 to 80/8. Answer 74.html 419 bytes
17. Subqueries - Questions and Answers 41 to 50/8. Answer 44.html 418 bytes
11. Correlated Subqueries A Must-Know Tool/14. CODE Correlated Subquery - More Exercise with Solution.html 416 bytes
18. Subqueries - Questions and Answers 51 to 60/18. Answer 59.html 415 bytes
11. Correlated Subqueries A Must-Know Tool/8. CODE Correlated Subquery - Customers who have not placed any order in condiment.html 414 bytes
3. Hands-On Exercise and Solutions Nested Subqueries/13. Question - Employees in Charge of Seattle.srt 411 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/38. CODE Solution - Customers Who Ordered from a Specific Supplier.html 411 bytes
11. Correlated Subqueries A Must-Know Tool/6. CODE Correlated Subquery - At one order in Beverages category.html 409 bytes
15. Subqueries - Questions and Answers 21 to 30/14. Answer 27.html 409 bytes
19. Subqueries - Questions and Answers 61 to 70/10. Answer 65.html 407 bytes
21. Subqueries - Questions and Answers 81 to 90/8. Answer 84.html 402 bytes
22. Subqueries - Questions and Answers 91 to 100/2. Answer 91.html 402 bytes
14. Subqueries - Questions and Answers 11 to 20/8. Answer 14.html 401 bytes
19. Subqueries - Questions and Answers 61 to 70/14. Answer 67.html 400 bytes
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/9. CODE CTE - Top Selling Products.html 397 bytes
25. Subqueries - Questions and Answers 121 to 130/10. Answer 125.html 396 bytes
15. Subqueries - Questions and Answers 21 to 30/8. Answer 24.html 390 bytes
23. Subqueries - Questions and Answers 101 to 110/12. Answer 106.html 390 bytes
19. Subqueries - Questions and Answers 61 to 70/6. Answer 63.html 389 bytes
16. Subqueries - Questions and Answers 31 to 40/6. Answer 33.html 387 bytes
18. Subqueries - Questions and Answers 51 to 60/12. Answer 56.html 387 bytes
14. Subqueries - Questions and Answers 11 to 20/2. Answer 11.html 382 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/50. CODE Nested Subquery - Employees who have the same territories.html 380 bytes
13. Subqueries - Questions and Answers 1 to 10/12. Answer 6.html 379 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/44. CODE Solution - AveragePrice, Products and Customers.html 378 bytes
15. Subqueries - Questions and Answers 21 to 30/4. Answer 22.html 372 bytes
3. Hands-On Exercise and Solutions Nested Subqueries/10. Question - Customers who ordered beverages products.srt 372 bytes
23. Subqueries - Questions and Answers 101 to 110/8. Answer 104.html 371 bytes
17. Subqueries - Questions and Answers 41 to 50/6. Answer 43.html 370 bytes
20. Subqueries - Questions and Answers 71 to 80/6. Answer 73.html 370 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/35. CODE Solution - Join - Customer Purchased above 100 dollars.html 367 bytes
20. Subqueries - Questions and Answers 71 to 80/20. Answer 80.html 366 bytes
13. Subqueries - Questions and Answers 1 to 10/14. Answer 7.html 364 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/38. CODE Nested Subquery - Customers who placed orders.html 364 bytes
5. The Power of SQL Joins and Subqueries Techniques for Writing Advanced Queries/10. CODE Question & Solution 5 - Join & Subquery.html 364 bytes
8. In-Line View Subqueries Levelling Up Your SQL Skills/11. CODE Inline View - Top 10 By Quantity Sold.html 363 bytes
17. Subqueries - Questions and Answers 41 to 50/2. Answer 41.html 361 bytes
3. Hands-On Exercise and Solutions Nested Subqueries/28. Question - Customers Ordered UK Suppliers Products.srt 361 bytes
22. Subqueries - Questions and Answers 91 to 100/12. Answer 96.html 354 bytes
21. Subqueries - Questions and Answers 81 to 90/4. Answer 82.html 350 bytes
11. Correlated Subqueries A Must-Know Tool/10. CODE Correlated Subquery - Products not ordered by customers from Germany.html 349 bytes
16. Subqueries - Questions and Answers 31 to 40/4. Answer 32.html 346 bytes
22. Subqueries - Questions and Answers 91 to 100/18. Answer 99.html 343 bytes
14. Subqueries - Questions and Answers 11 to 20/14. Answer 17.html 342 bytes
18. Subqueries - Questions and Answers 51 to 60/16. Answer 58.html 342 bytes
11. Correlated Subqueries A Must-Know Tool/12. CODE Correlated Subquery - Customers Placed Orders for Discontinued products.html 340 bytes
21. Subqueries - Questions and Answers 81 to 90/10. Answer 85.html 339 bytes
15. Subqueries - Questions and Answers 21 to 30/10. Answer 25.html 337 bytes
17. Subqueries - Questions and Answers 41 to 50/4. Answer 42.html 335 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/48. CODE Nested Subquery - Order Placed in 2008.html 334 bytes
20. Subqueries - Questions and Answers 71 to 80/18. Answer 79.html 334 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/30. CODE Nested Subquery - Employee under managers who have managers.html 333 bytes
15. Subqueries - Questions and Answers 21 to 30/6. Answer 23.html 331 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/32. CODE Solution - Join - CategoryName and TotalQuantity.html 328 bytes
13. Subqueries - Questions and Answers 1 to 10/20. Answer 10.html 327 bytes
14. Subqueries - Questions and Answers 11 to 20/10. Answer 15.html 327 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/52. CODE Nested Subquery - Products ordered by customers.html 326 bytes
21. Subqueries - Questions and Answers 81 to 90/6. Answer 83.html 326 bytes
29. (Optional) Basic SQL Queries/27. Where and By Example.srt 324 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/60. Question - Average UnitPrice, Supplier and Customers from France.srt 319 bytes
13. Subqueries - Questions and Answers 1 to 10/2. Answer 1.html 318 bytes
18. Subqueries - Questions and Answers 51 to 60/8. Answer 54.html 318 bytes
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/5. CODE Scalar Subquery - Employees who sold more than 100k.html 315 bytes
17. Subqueries - Questions and Answers 41 to 50/18. Answer 49.html 314 bytes
17. Subqueries - Questions and Answers 41 to 50/14. Answer 47.html 312 bytes
16. Subqueries - Questions and Answers 31 to 40/14. Answer 37.html 310 bytes
18. Subqueries - Questions and Answers 51 to 60/6. Answer 53.html 310 bytes
8. In-Line View Subqueries Levelling Up Your SQL Skills/7. CODE Inline View - Top 5 Customers By Total Orders.html 310 bytes
14. Subqueries - Questions and Answers 11 to 20/12. Answer 16.html 305 bytes
18. Subqueries - Questions and Answers 51 to 60/10. Answer 55.html 305 bytes
20. Subqueries - Questions and Answers 71 to 80/4. Answer 72.html 304 bytes
23. Subqueries - Questions and Answers 101 to 110/10. Answer 105.html 304 bytes
18. Subqueries - Questions and Answers 51 to 60/20. Answer 60.html 299 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/22. CODE Nested Subquery - Supplied categories of seafood.html 298 bytes
14. Subqueries - Questions and Answers 11 to 20/16. Answer 18.html 296 bytes
16. Subqueries - Questions and Answers 31 to 40/10. Answer 35.html 291 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/19. CODE Inner Join - Quantity of Product, ProductName and Suppliers.html 290 bytes
26. Subqueries - Questions and Answers 131 to 140/4. Answer 132.html 286 bytes
14. Subqueries - Questions and Answers 11 to 20/4. Answer 12.html 285 bytes
13. Subqueries - Questions and Answers 1 to 10/10. Answer 5.html 282 bytes
18. Subqueries - Questions and Answers 51 to 60/14. Answer 57.html 282 bytes
16. Subqueries - Questions and Answers 31 to 40/8. Answer 34.html 281 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/29. CODE Suppliers, Products and Total Quantity.html 281 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/34. CODE Nested Subquery - Territories names Assigned to Employees.html 275 bytes
14. Subqueries - Questions and Answers 11 to 20/6. Answer 13.html 271 bytes
13. Subqueries - Questions and Answers 1 to 10/8. Answer 4.html 268 bytes
16. Subqueries - Questions and Answers 31 to 40/2. Answer 31.html 268 bytes
16. Subqueries - Questions and Answers 31 to 40/12. Answer 36.html 264 bytes
7. Common Table Expression Subquery (CTE) Mastering Your SQL Craft/3. CODE CTE Subquery by Example.html 264 bytes
14. Subqueries - Questions and Answers 11 to 20/18. Answer 19.html 260 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/11. CODE USING with Join.html 259 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/39. Question - Customer, Supplier, Quantity and Total Price.srt 249 bytes
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/9. CODE Scalar Subquery - Categories where average unit price greater than $30.html 249 bytes
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/11. CODE Scalar Subquery - Orders of employees with fewest orders.html 244 bytes
6. Single-Row Subqueries Single-Row Subqueries Demystified/13. CODE Example 6 - Most Expensive Products Per Category.html 236 bytes
11. Correlated Subqueries A Must-Know Tool/2. CODE Understanding Correlated Subquery I.html 235 bytes
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/3. CODE Multiple-Rows Subquery - Products Ordered More Than 50 Times.html 227 bytes
28. Subqueries - Questions and Answers 151 to 160/17. Question 159.html 224 bytes
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/9. CODE Multiple-Rows Subquery -Categories with at least 10 products.html 222 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/27. CODE Number of Orders per Employee Exercise with Solution.html 221 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/54. CODE Nested Subquery - Employees Managed by Funk.html 218 bytes
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/7. CODE Scalar Subquery - Orders shipped by the most recent Employee.html 215 bytes
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/13. CODE Multiple-Rows Subquery - Products that have UnitPrice greater than its cat.html 214 bytes
9. Scalar Subqueries Elevating Your SQL Game to the Next Level/3. CODE Scalar Subquery - Customers with Orders More than 20.html 214 bytes
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/5. CODE Multiple-Rows Subquery - Customers who placed orders in 2008.html 212 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/2. CODE Nested Subquery - SubQuery with LIKE.html 208 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/28. CODE Nested Subquery - Products with reorderLevel.html 208 bytes
1. Introduction to SQL Subquery/9. CODE Beginning Subquery - With Example III.html 206 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/46. CODE Nested Subquery - Employees not assigned to Territories.html 205 bytes
1. Introduction to SQL Subquery/5. CODE Beginning Subquery - With Example I.html 203 bytes
28. Subqueries - Questions and Answers 151 to 160/13. Question 157.html 201 bytes
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/11. CODE Multiple-Rows Subquery - Suppliers with product more than 100.html 199 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/42. CODE Nested Subquery - Territories never assign to Employees.html 199 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/25. CODE Customers, Employee and Orders.html 198 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/36. CODE Nested Subquery - Products Supplied by Same Company.html 197 bytes
17. Subqueries - Questions and Answers 41 to 50/16. Answer 48.html 196 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/44. CODE Nested Subquery - Customers Who Never Placed Orders.html 187 bytes
18. Subqueries - Questions and Answers 51 to 60/5. Question 53.html 185 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/40. CODE Nested Subquery - Products never ordered.html 185 bytes
17. Subqueries - Questions and Answers 41 to 50/12. Answer 46.html 181 bytes
27. Subqueries - Questions and Answers 141 to 150/17. Question 149.html 181 bytes
17. Subqueries - Questions and Answers 41 to 50/10. Answer 45.html 178 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/17. CODE Inner Join - Product Name, Supplier and Category.html 175 bytes
28. Subqueries - Questions and Answers 151 to 160/3. Question 152.html 171 bytes
26. Subqueries - Questions and Answers 131 to 140/19. Question 140.html 170 bytes
27. Subqueries - Questions and Answers 141 to 150/9. Question 145.html 169 bytes
27. Subqueries - Questions and Answers 141 to 150/15. Question 148.html 167 bytes
25. Subqueries - Questions and Answers 121 to 130/15. Question 128.html 165 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/20. CODE Nested Subquery - Freight of orders.html 163 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/6. CODE Nested Subquery- Employee Territories.html 163 bytes
27. Subqueries - Questions and Answers 141 to 150/11. Question 146.html 163 bytes
27. Subqueries - Questions and Answers 141 to 150/5. Question 143.html 163 bytes
26. Subqueries - Questions and Answers 131 to 140/1. Question 131.html 162 bytes
24. Subqueries - Questions and Answers 111 to 120/5. Question 113.html 161 bytes
27. Subqueries - Questions and Answers 141 to 150/19. Question 150.html 161 bytes
21. Subqueries - Questions and Answers 81 to 90/1. Question 81.html 160 bytes
22. Subqueries - Questions and Answers 91 to 100/7. Question 94.html 160 bytes
25. Subqueries - Questions and Answers 121 to 130/13. Question 127.html 160 bytes
28. Subqueries - Questions and Answers 151 to 160/11. Question 156.html 159 bytes
15. Subqueries - Questions and Answers 21 to 30/15. Question 28.html 158 bytes
10. Multiple-row Subqueries Empowering Your Data Analysis Skill/7. CODE Multiple-Rows Subquery - Employees that have made at least one sales.html 156 bytes
6. Single-Row Subqueries Single-Row Subqueries Demystified/5. CODE Example 2 - Customer Who Placed the latest Order.html 155 bytes
15. Subqueries - Questions and Answers 21 to 30/9. Question 25.html 154 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/26. CODE Nested Subquery - Employees with same manager.html 154 bytes
26. Subqueries - Questions and Answers 131 to 140/7. Question 134.html 152 bytes
18. Subqueries - Questions and Answers 51 to 60/17. Question 59.html 151 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/7. CODE Indicating Source of Columns.html 150 bytes
25. Subqueries - Questions and Answers 121 to 130/19. Question 130.html 148 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/23. CODE HAVING - Understanding Having Example.html 146 bytes
24. Subqueries - Questions and Answers 111 to 120/7. Question 114.html 145 bytes
28. Subqueries - Questions and Answers 151 to 160/7. Question 154.html 145 bytes
15. Subqueries - Questions and Answers 21 to 30/17. Question 29.html 144 bytes
17. Subqueries - Questions and Answers 41 to 50/5. Question 43.html 144 bytes
18. Subqueries - Questions and Answers 51 to 60/9. Question 55.html 144 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/4. CODE Nested Subquery - Mangers of Employee SubQueries.html 144 bytes
27. Subqueries - Questions and Answers 141 to 150/3. Question 142.html 143 bytes
27. Subqueries - Questions and Answers 141 to 150/7. Question 144.html 142 bytes
25. Subqueries - Questions and Answers 121 to 130/3. Question 122.html 141 bytes
20. Subqueries - Questions and Answers 71 to 80/3. Question 72.html 140 bytes
22. Subqueries - Questions and Answers 91 to 100/3. Question 92.html 140 bytes
22. Subqueries - Questions and Answers 91 to 100/11. Question 96.html 139 bytes
14. Subqueries - Questions and Answers 11 to 20/1. Question 11.html 138 bytes
22. Subqueries - Questions and Answers 91 to 100/1. Question 91.html 138 bytes
25. Subqueries - Questions and Answers 121 to 130/5. Question 123.html 138 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/18. CODE Nested Subquery - Territories not assigned to employee.html 137 bytes
28. Subqueries - Questions and Answers 151 to 160/15. Question 158.html 137 bytes
14. Subqueries - Questions and Answers 11 to 20/5. Question 13.html 136 bytes
13. Subqueries - Questions and Answers 1 to 10/19. Question 10.html 135 bytes
18. Subqueries - Questions and Answers 51 to 60/7. Question 54.html 135 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/8. CODE Nested Subquery - CategoryName.html 135 bytes
23. Subqueries - Questions and Answers 101 to 110/7. Question 104.html 135 bytes
15. Subqueries - Questions and Answers 21 to 30/3. Question 22.html 134 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/10. CODE Nested Subquery - Suppliers.html 134 bytes
23. Subqueries - Questions and Answers 101 to 110/19. Question 110.html 134 bytes
17. Subqueries - Questions and Answers 41 to 50/13. Question 47.html 133 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/3. CODE Introduction to Inner Join by Example.html 133 bytes
4. Mastering SQL JOIN A Prerequisite for Advanced Subquery Courses/5. CODE Rearranging your query.html 133 bytes
24. Subqueries - Questions and Answers 111 to 120/19. Question 120.html 132 bytes
25. Subqueries - Questions and Answers 121 to 130/7. Question 124.html 132 bytes
26. Subqueries - Questions and Answers 131 to 140/11. Question 136.html 132 bytes
14. Subqueries - Questions and Answers 11 to 20/11. Question 16.html 131 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/16. CODE Nested Subquery - Employees with same region.html 131 bytes
20. Subqueries - Questions and Answers 71 to 80/1. Question 71.html 131 bytes
24. Subqueries - Questions and Answers 111 to 120/3. Question 112.html 131 bytes
18. Subqueries - Questions and Answers 51 to 60/19. Question 60.html 129 bytes
25. Subqueries - Questions and Answers 121 to 130/9. Question 125.html 129 bytes
28. Subqueries - Questions and Answers 151 to 160/5. Question 153.html 129 bytes
15. Subqueries - Questions and Answers 21 to 30/11. Question 26.html 128 bytes
22. Subqueries - Questions and Answers 91 to 100/13. Question 97.html 128 bytes
22. Subqueries - Questions and Answers 91 to 100/5. Question 93.html 128 bytes
28. Subqueries - Questions and Answers 151 to 160/9. Question 155.html 128 bytes
13. Subqueries - Questions and Answers 1 to 10/13. Question 7.html 127 bytes
13. Subqueries - Questions and Answers 1 to 10/5. Question 3.html 127 bytes
21. Subqueries - Questions and Answers 81 to 90/5. Question 83.html 127 bytes
23. Subqueries - Questions and Answers 101 to 110/1. Question 101.html 127 bytes
15. Subqueries - Questions and Answers 21 to 30/7. Question 24.html 126 bytes
17. Subqueries - Questions and Answers 41 to 50/17. Question 49.html 126 bytes
21. Subqueries - Questions and Answers 81 to 90/9. Question 85.html 126 bytes
25. Subqueries - Questions and Answers 121 to 130/1. Question 121.html 126 bytes
25. Subqueries - Questions and Answers 121 to 130/17. Question 129.html 125 bytes
13. Subqueries - Questions and Answers 1 to 10/17. Question 9.html 124 bytes
18. Subqueries - Questions and Answers 51 to 60/11. Question 56.html 124 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/32. CODE Nested Subquery - Supplier who live in Spain.html 124 bytes
26. Subqueries - Questions and Answers 131 to 140/13. Question 137.html 124 bytes
15. Subqueries - Questions and Answers 21 to 30/1. Question 21.html 123 bytes
16. Subqueries - Questions and Answers 31 to 40/1. Question 31.html 123 bytes
16. Subqueries - Questions and Answers 31 to 40/13. Question 37.html 123 bytes
16. Subqueries - Questions and Answers 31 to 40/3. Question 32.html 123 bytes
24. Subqueries - Questions and Answers 111 to 120/1. Question 111.html 123 bytes
24. Subqueries - Questions and Answers 111 to 120/9. Question 115.html 123 bytes
26. Subqueries - Questions and Answers 131 to 140/5. Question 133.html 123 bytes
28. Subqueries - Questions and Answers 151 to 160/19. Question 160.html 123 bytes
16. Subqueries - Questions and Answers 31 to 40/15. Question 38.html 122 bytes
17. Subqueries - Questions and Answers 41 to 50/7. Question 44.html 122 bytes
19. Subqueries - Questions and Answers 61 to 70/5. Question 63.html 122 bytes
23. Subqueries - Questions and Answers 101 to 110/11. Question 106.html 122 bytes
6. Single-Row Subqueries Single-Row Subqueries Demystified/3. CODE Example 1 - Employee who has been with the company the longest.html 122 bytes
15. Subqueries - Questions and Answers 21 to 30/13. Question 27.html 121 bytes
19. Subqueries - Questions and Answers 61 to 70/13. Question 67.html 121 bytes
22. Subqueries - Questions and Answers 91 to 100/19. Question 100.html 121 bytes
23. Subqueries - Questions and Answers 101 to 110/3. Question 102.html 121 bytes
14. Subqueries - Questions and Answers 11 to 20/15. Question 18.html 120 bytes
14. Subqueries - Questions and Answers 11 to 20/17. Question 19.html 120 bytes
19. Subqueries - Questions and Answers 61 to 70/11. Question 66.html 120 bytes
21. Subqueries - Questions and Answers 81 to 90/3. Question 82.html 120 bytes
26. Subqueries - Questions and Answers 131 to 140/17. Question 139.html 120 bytes
27. Subqueries - Questions and Answers 141 to 150/1. Question 141.html 120 bytes
14. Subqueries - Questions and Answers 11 to 20/13. Question 17.html 119 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/14. CODE Nested Subquery - Employee Without Orders.html 119 bytes
26. Subqueries - Questions and Answers 131 to 140/9. Question 135.html 119 bytes
6. Single-Row Subqueries Single-Row Subqueries Demystified/7. CODE Example 3 - Product with highest unitPrice.html 119 bytes
14. Subqueries - Questions and Answers 11 to 20/9. Question 15.html 118 bytes
19. Subqueries - Questions and Answers 61 to 70/9. Question 65.html 118 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/24. CODE Nested Subquery - customers in the same city.html 118 bytes
24. Subqueries - Questions and Answers 111 to 120/11. Question 116.html 118 bytes
26. Subqueries - Questions and Answers 131 to 140/15. Question 138.html 118 bytes
15. Subqueries - Questions and Answers 21 to 30/5. Question 23.html 116 bytes
16. Subqueries - Questions and Answers 31 to 40/5. Question 33.html 116 bytes
13. Subqueries - Questions and Answers 1 to 10/9. Question 5.html 114 bytes
2. Nested Subqueries Techniques for Mastering Complex Data Retrieval/12. CODE Nested Subquery - Product Ordered.html 114 bytes
13. Subqueries - Questions and Answers 1 to 10/15. Question 8.html 113 bytes
18. Subqueries - Questions and Answers 51 to 60/1. Question 51.html 113 bytes
16. Subqueries - Questions and Answers 31 to 40/7. Question 34.html 111 bytes
22. Subqueries - Questions and Answers 91 to 100/15. Question 98.html 110 bytes
24. Subqueries - Questions and Answers 111 to 120/13. Question 117.html 110 bytes
21. Subqueries - Questions and Answers 81 to 90/15. Question 88.html 109 bytes
16. Subqueries - Questions and Answers 31 to 40/19. Question 40.html 108 bytes
19. Subqueries - Questions and Answers 61 to 70/17. Question 69.html 108 bytes
20. Subqueries - Questions and Answers 71 to 80/11. Question 76.html 108 bytes
20. Subqueries - Questions and Answers 71 to 80/9. Question 75.html 108 bytes
18. Subqueries - Questions and Answers 51 to 60/13. Question 57.html 107 bytes
20. Subqueries - Questions and Answers 71 to 80/15. Question 78.html 107 bytes
24. Subqueries - Questions and Answers 111 to 120/17. Question 119.html 106 bytes
17. Subqueries - Questions and Answers 41 to 50/1. Question 41.html 105 bytes
21. Subqueries - Questions and Answers 81 to 90/13. Question 87.html 105 bytes
21. Subqueries - Questions and Answers 81 to 90/7. Question 84.html 105 bytes
6. Single-Row Subqueries Single-Row Subqueries Demystified/9. CODE Example 4 - Order with Highest Freight Value..html 105 bytes
14. Subqueries - Questions and Answers 11 to 20/19. Question 20.html 104 bytes
14. Subqueries - Questions and Answers 11 to 20/3. Question 12.html 104 bytes
17. Subqueries - Questions and Answers 41 to 50/15. Question 48.html 104 bytes
18. Subqueries - Questions and Answers 51 to 60/15. Question 58.html 104 bytes
23. Subqueries - Questions and Answers 101 to 110/5. Question 103.html 104 bytes
23. Subqueries - Questions and Answers 101 to 110/9. Question 105.html 104 bytes
29. (Optional) Basic SQL Queries/16. CODE Understanding WHERE (Filter).html 103 bytes
25. Subqueries - Questions and Answers 121 to 130/11. Question 126.html 102 bytes
13. Subqueries - Questions and Answers 1 to 10/11. Question 6.html 101 bytes
13. Subqueries - Questions and Answers 1 to 10/7. Question 4.html 101 bytes
14. Subqueries - Questions and Answers 11 to 20/7. Question 14.html 101 bytes
15. Subqueries - Questions and Answers 21 to 30/19. Question 30.html 100 bytes
19. Subqueries - Questions and Answers 61 to 70/15. Question 68.html 100 bytes
26. Subqueries - Questions and Answers 131 to 140/3. Question 132.html 100 bytes
22. Subqueries - Questions and Answers 91 to 100/9. Question 95.html 98 bytes
20. Subqueries - Questions and Answers 71 to 80/7. Question 74.html 97 bytes
21. Subqueries - Questions and Answers 81 to 90/11. Question 86.html 97 bytes
23. Subqueries - Questions and Answers 101 to 110/13. Question 107.html 97 bytes
20. Subqueries - Questions and Answers 71 to 80/13. Question 77.html 95 bytes
16. Subqueries - Questions and Answers 31 to 40/17. Question 39.html 94 bytes
17. Subqueries - Questions and Answers 41 to 50/9. Question 45.html 94 bytes
19. Subqueries - Questions and Answers 61 to 70/7. Question 64.html 94 bytes
17. Subqueries - Questions and Answers 41 to 50/11. Question 46.html 90 bytes
22. Subqueries - Questions and Answers 91 to 100/17. Question 99.html 89 bytes
29. (Optional) Basic SQL Queries/20. CODE Where and By Example.html 89 bytes
20. Subqueries - Questions and Answers 71 to 80/19. Question 80.html 88 bytes
24. Subqueries - Questions and Answers 111 to 120/15. Question 118.html 88 bytes
28. Subqueries - Questions and Answers 151 to 160/1. Question 151.html 88 bytes
23. Subqueries - Questions and Answers 101 to 110/17. Question 109.html 87 bytes
19. Subqueries - Questions and Answers 61 to 70/19. Question 70.html 86 bytes
17. Subqueries - Questions and Answers 41 to 50/19. Question 50.html 84 bytes
19. Subqueries - Questions and Answers 61 to 70/1. Question 61.html 84 bytes
19. Subqueries - Questions and Answers 61 to 70/3. Question 62.html 84 bytes
21. Subqueries - Questions and Answers 81 to 90/17. Question 89.html 84 bytes
29. (Optional) Basic SQL Queries/26. CODE Where and = By Example.html 84 bytes
29. (Optional) Basic SQL Queries/30. CODE Where and = By Example.html 84 bytes
27. Subqueries - Questions and Answers 141 to 150/13. Question 147.html 83 bytes
29. (Optional) Basic SQL Queries/24. CODE Where and By Example.html 83 bytes
29. (Optional) Basic SQL Queries/28. CODE Where and By Example.html 83 bytes
20. Subqueries - Questions and Answers 71 to 80/5. Question 73.html 82 bytes
29. (Optional) Basic SQL Queries/18. CODE Where and = by Example.html 81 bytes
17. Subqueries - Questions and Answers 41 to 50/3. Question 42.html 80 bytes
21. Subqueries - Questions and Answers 81 to 90/19. Question 90.html 79 bytes
23. Subqueries - Questions and Answers 101 to 110/15. Question 108.html 76 bytes
29. (Optional) Basic SQL Queries/22. CODE Where and != By Example.html 75 bytes
18. Subqueries - Questions and Answers 51 to 60/3. Question 52.html 73 bytes
16. Subqueries - Questions and Answers 31 to 40/11. Question 36.html 71 bytes
20. Subqueries - Questions and Answers 71 to 80/17. Question 79.html 69 bytes
16. Subqueries - Questions and Answers 31 to 40/9. Question 35.html 64 bytes
29. (Optional) Basic SQL Queries/12. CODE Distinct on multiple columns.html 62 bytes
29. (Optional) Basic SQL Queries/14. CODE Distinct on multiple columns II.html 58 bytes
13. Subqueries - Questions and Answers 1 to 10/1. Question 1.html 57 bytes
29. (Optional) Basic SQL Queries/8. CODE Selecting Multiple columns II.html 50 bytes
13. Subqueries - Questions and Answers 1 to 10/3. Question 2.html 45 bytes
29. (Optional) Basic SQL Queries/10. CODE How to use DISTINCT.html 45 bytes
29. (Optional) Basic SQL Queries/6. CODE Selecting Multiple columns.html 43 bytes
29. (Optional) Basic SQL Queries/4. CODE Selecting a Specific Column.html 31 bytes
29. (Optional) Basic SQL Queries/2. CODE Selecting all columns.html 30 bytes

Udemy - SQL & MySQL Subqueries Understanding the weird parts (3.2023)

File List

Download Torrent

Related Resources

Copyright Infringement