SQL WITH Clause | Clearly Explained | CTEs vs Subqueries vs Temp Tables | Recursive CTEs

[@brentvanscoy]

Best SQL tutorial I have ever seen; Brilliant!

[@surawick]

Very Clear & informative !! Thanks a lot ❤❤

[@longinos10]

I was watching other videos before this one, and I just couldn't wrap my head around it, and this video was clear as crystal

[@torpedoe1936]

This is so clearly explained and concise. Thanx a bunch ma'am!

[@ovoparadise]

I quickly subscribed and liked, she killed the CTE lesson. Hats off!!

[@Qubom]

This is maybe the best SQL guide on youtube, thank you, Alice!

[@Alice-at-Maven]

You're welcome! 🙌

[@momohtimothy6898]

Finally, I can now see and understand subqueries. Thank you.

[@Alice-at-Maven]

Glad to hear that!

[@sravyath]

@@Alice-at-Maven mam how can I get a course from you?

[@Alice-at-Maven]

@@sravyath You can find my Data Science in Python courses at Maven Analytics or Udemy. I have an Advanced SQL course coming out next month on the same two platforms, so stay tuned!

[@rodrigochavez7]

Amazing explanation as always! The most complete and clear video about this topic. Thank you Alice!

[@Alice-at-Maven]

You're welcome!

[@sambacarlson]

This is an awesome video. the material she covers clearly in 30 minutes will take one hours to study on their own

[@0xJarry]

Thank you for such an amazing presentation... big case of you don't know what you don't know for me... cant wait to research more on how CTEs will be useful for me

[@Alice-at-Maven]

Glad to hear that. Happy learning!

[@iurgnail]

great video. informative, concise, good framework, clear

[@walidherz7132]

Thank you for your well presented videos. I hope to see more videos from you regarding SQL server

[@ugochiturumokonkwo4801]

Great content, great style, concise and simple to understand.

[@Alice-at-Maven]

Glad you enjoyed it!

[@YJTSLA]

It was so clear and easy to understand, thank you so much Alice! Hope to have your SQL course one day :)

[@Alice-at-Maven]

Glad to hear that! My advanced SQL querying course comes out next month on the Maven Analytics platform. Stay tuned!

[@gustavojuantorena]

So much better explanation that my professor. Thank you!

[@Valeria-vf9bx]

Wow! Thank you so much for the explanation, definitely helped me understand everything much better

[@osoriomatucurane9511]

Awesome tutorial, crystal clear a d concise. Well done. 1. CTE is elegant. I would go for CTE when the first query returns a table, and go for subquery when the result set of the first query goes into select or where clauses as sclares or list/tuple. 2. Can get access to the dataset used here. 3. I quickly took a glance. At your SQL trainning program and it seems you dive deep and cover quite a lot than most SQL trainning programs in the market. Please advise the rate. Thank u

[@MavenAnalytics]

Glad you enjoyed the video! 1. That's a great workflow 2. You can download the Restaurant Orders data set (and many more!) for free on our data playground: mavenanalytics.io/data-playground 3. Our SQL courses are available on the Maven Analytics platform for a monthly fee (mavenanalytics.io/signup/pricing) or on Udemy for a per course fee (www.udemy.com/user/maven-analytics/)

[@Dadzie.emmanuel]

At long last, I have met a good teacher 😂. Thank you so much ma'am 🎉

[@Alice-at-Maven]

You're welcome 😃

[@ICanDoCode]

🎉no words enough to say my thanks here

[@JoelPasapera]

Hi, this video was really helpful, despite is not i'm My mother language, the logic that You provide is clearly than in spanish

[@gospelmoto2833]

WOW!!!! that was amazing, I learned a lot. Thank so much. Got a new sub here.

[@Alice-at-Maven]

Thank you! Glad you found it helpful 🙌

[@JhulanDey]

as usual super fantastic.. what about a total series for beginners? u r definitely one of the best in explaining!

[@MavenAnalytics]

Here's our SQL for Beginners video: kzbin.info/www/bejne/lafboJV3aJuIhJY Enjoy!

[@enthusiast1]

Great video, very clear, essy to follow, thank you! 💯👏 An aside... your production quality, including audio quality, is high... makes it so much easier to follow when "room.echo" or similar is not in the way.

[@Alice-at-Maven]

Thanks so much for the positive feedback!

[@sindhuvignesh1012]

Super Informative. Thank you

[@phariharavarma8103]

In the first example can't we simply use having clause to filter records having max price less than 15 instead of using a CTE or subquery?

[@Alice-at-Maven]

Yep! You can absolutely use HAVING instead for the filtering portion. However, the COUNT(*) portion requires a subquery or CTE.

[@veguitascript3322]

Thank you Alice for your marvellous work!! I have a query, what is the database that you use in the point number 4, that has a table named stock_prices and the others one. if it would not be too much trouble, could you tell us where we can find it, thank you very much in advance

[@MavenAnalytics]

Here you go! CREATE TABLE stock_prices ( date DATE PRIMARY KEY, price DECIMAL(10, 2) ); INSERT INTO stock_prices (date, price) VALUES ('2024-06-01', 668.27), ('2024-06-03', 678.83), ('2024-06-04', 635.40), ('2024-06-06', 591.01);

[@veguitascript3322]

​@@MavenAnalyticscould you give the script of the table my_dates. Please :3

[@Adarsh-vr5wy]

8:27 Temp Tables.

[@juandoza5867]

LOVE IT

[@utkarshkunwar4319]

Thank you so much for explaining this, Alice! Would it be possible to get hold of the table you are using in this video? I guess having access to same would make it easy to follow along.

[@MavenAnalytics]

Of course! You can find the menu items table details on the Maven Analytics data playground: www.mavenanalytics.io/data-playground?order=date_added%2Cdesc&search=restaurant%20orders

[@SM-vz1ek]

Hello, very clear explantion !! what software do you use ?

[@Alice-at-Maven]

For the demo, I'm using MySQL Workbench. Glad you enjoyed the video!

[@h0ph1p13]

How do you manage to explain it so well. I watched another video too and the explanation was nonsensical, tho the author seemed to know what they are talking about. So.. how do you explain, is there a method to it? I am very interested to be able to explain so clearly to other people

[@Alice-at-Maven]

My advice would be to break things down step by step and make things as practical as possible. Also, put yourself in the viewer's shoes - what would they know coming in, what questions would they have throughout, etc. - and do your best to address those things every step of the way. Good luck!

[@h0ph1p13]

@@Alice-at-Maven Thanks a lot, Alice!

[@m-43-prateekkumar27]

Amazing

[@Suma7777-qh4nn]

If someone hates to see 10 hour courses vedios and getting tied ignore watch this kind of vedios

[@Bhaskar_Joshi_there]

Where can I find your SQL courses? Where you're teaching as a instructor.

[@MavenAnalytics]

You can find all our courses at: mavenanalytics.io/online-data-analysis-courses 🙌

[@omilkhouseo]

❤

[@diamondsandlipgloss]

a CTE must be advanced because I'm confused.... I'll have to re-watch a bunch of times until I understand

[@MavenAnalytics]

Yes, CTEs are an advanced topic! To understand them, we recommend first getting a solid grasp of the Big 6 and then getting some more exposure to subqueries. 1. Our Big 6 video: kzbin.info/www/bejne/r5iXi5uon9aMnJo 2. Our SQL guided project video (subquery example starts at 17:52): kzbin.info/www/bejne/gJK4fHeYeL2AjpY

[@diamondsandlipgloss]

@@MavenAnalytics thanks for the links!