Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How to do Subqueries in SQL with Examples. That video is uploaded by Becoming a Data Scientist at 2020-01-15T07:00:04-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [GpC0XyiJPEo]
| Name | How to do Subqueries in SQL with Examples |
| Video Uploader | Video From Becoming a Data Scientist |
| Upload Date | This Video Uploaded At 15-01-2020 15:00:04 |
| Video Discription | Step-by-step tutorial shows you how to use SQL subqueries in your SELECT statement & FROM and WHERE clauses! Queries: 1) A subquery in the SELECT statement: SELECT customerid, freight, (SELECT AVG(freight) FROM orders) FROM orders 2) A subquery in the FROM clause: SELECT shipcountry, AVG(num_orders) FROM (SELECT customerid, shipcountry, count(*) AS num_orders FROM orders GROUP BY 1,2) sub GROUP BY 1 3) A subquery in the WHERE clause: SELECT * FROM orders WHERE employeeid IN (SELECT employeeid FROM employees WHERE LOWER(firstname) LIKE '%b%') Get the Northwind Database: https://www.youtube.com/watch?v=nbIicI7K6Kk Support the Channel: 1) Subscribe: https://www.becomingads.com/o/youtube 2) DataCamp: https://www.becomingads.com/o/datacamp 3) Udacity: https://www.becomingads.com/o/udacity GpC0XyiJPEo |
| Category | Science & Technology |
| Tags | becoming a data scientist | becomingads.com | data science | data scientist | sql subquery | postgresql subquery | sql subqueries | postgresql subqueries | sql subquery example |
