Super useful and insightful, just would be perfect is actual example would be given, how are these techniques are used in a professional setting, as in what problems do we solve with these, I guess there are many and too much to cite them all but a few would have been nice :) Feel free fellow commenters to answer this comments with a few ways these can be used and applied if you know !

Thanks bro

Thank you

Group By 1 can u pls explain this

really helpful, thank you so much <3

thanks

is there a new link for git bash? the current one is spammy af :(

this is more helpful than my teacher's exp

Thank you.

thanks that was very helpful

Thank you. It was wonderful explanation

Really? You are doing a video on these basal things?

where is your ER diagram? or where are you getting the info to make your queries

In just 5 minutes, i've sorted out my confusion with WHERE and GROUP BY. Self study >>>>>

Just subscribed thank you for all your information you break it down so well

My professors are dumb as shit. You made this simple! Thanks

God dam {} means they are place holders took me hood 5 days to understand this thank you, holy jesus IM NOT GONA BE MENTALLY OKAY AFTER LEARNING IT

I don't understand what the ctdorders have inside...

NIce video!

Thanks a lot for the video, very clear and helpful!

What link? There are no links to download the sample database.

Oh my gosh! You answered the question that was stumping me the last few days. I’m taking the google analytics course and I keep having errors with my aggregate functions. When you added city to the SELECT clause, I keep doing that with the data set I’m working on and keep getting an error message. Then I saw you added country and city under GROUP BY which I have never done before so I think your video was the answer to my question. Thank you!!!

great content. Thank you for sharing

Wouldn't it be easier simply to drag the folder into the editor? I can do that with iTerm because it creates a complete path to that folder.

Good video man

It's very helpful

The idea that a subquery in a FROM statement creates a table and starting the query process from there was a real lightbulb moment - thank you

Very well done! Concise, to the point and no fluff. A+ 🙂

FYI: When writing a file path on PCs, you could use / in place of \\ if you want. I hope that this helps!

Thank you for this brilliant video. Please upload more :) :).

Thank you for the video. Please do upload more :) :).

Heyyyyyyy you're amazing person..... You teach so easily...... Please don't stop come back and upload videos

Thank you... It's helpful

How can I union two cte together, there is one sum on a budget, column are exactly the same I have group by , send me video please

Very helpful and easy to understand. Thanks

Очень хорошее видео. Автору спасибо

You are single-handedly saving my grade and finals preparation for my databases module. I appreciate all the hard work, thanks a ton!

what is the name of the software that u r using

You saved my but ❤

Very concise and clear! Thank you so much

Can I pass list of acctnumbers in with and it will traverse through each one of them to fetch acctid from diff table

Tbh these practices should already be outdated. Shouldn’t have to code to view simply data in a dataset in 2024

for two years I've been struggling to understand how and when to use these clauses and you just taught me all that in 6 minutes. You are a legend. Thank you. It is going to save me from a lot of trouble from my Uni exam next week

thank youuu <3

Thanks a lot for simple explanation

I'm not seeing the screen

Very helpful. Than you.

Your vedeo is helpful

Thanks very useful

it helped alot thank you for short and clear explnation