Aliasing is one of the best methods to reduce keystrokes!! This is perfect 🎉❤

everytime I hear the outro I feel like I accomplished something

Amazing! I have learnt a lot in such a short period of time and I am confident in the prospect of working on projects!

Thank you this course helped me realy

Amazing, Thank u so much Sir ALEX

If you give assignment questions and answers on each topic it will be very helpful for us to practice

Hey Alex thanks a lot for making SQL easy for us. I have a question Alex, when are you going to make videos on Intermediate and Advanced series on MySQL. And any projects on MySQL??

Great refresher on both LIMIT and ALIASING. For example, I don't think I've ever come across the whole "limit a certain number of rows" THEN "return the NEXT row" technique before. Wow, I knew I had a lot to learn and, in some cases, relearn... Good thing you have the Intermediate & Advanced lessons ready for me when I get there. Keep this up and you're going to get a Christmas card! Cheers

Sir this course is on point i can imagine your premium courses.

Make a video on statistics for data analysis

I am enjoying learning this course ok here so far 😊😊 but I am sorry Alex I currently can’t afford it on analyst builder 😢

Thank You alot, when should we expect the playlist for the intermediate and advanced for mysql

Thank you so much Alex it is helpful. Sorry Alex I have a question regarding the Bootcamp course I have started taking course do I have to complete all courses to get the certification of completion thank you in advance

Hi, I have a question- Is having clause executed before SELECT? If yes, how does aliasing works in the example you showed in the video? Thanks

Comment for algorithm, thanks for sharing!

Hey Alex, I want to ask something, If we can find the oldest, how about if we need the top 3 oldest and the top 3 youngest person in one table? hope you notice my question. thank you!

So why mysql vs mssql?

Can you extend your code 20% off. I thought it was on your website but i couldnt find it on which video it was on

3:10 the example is not clear, how average age and less than 40? I also did not understand where did the females go, disappearing from the output? Please explain. This GROUP BY is driving me crazy.

the limit 2,1 is not working in postgresql.............ERROR: LIMIT #,# syntax is not supported LINE 15: limit 2,1; ^ HINT: Use separate LIMIT and OFFSET clauses. .................the following is the error........is it a postgresql issue?????

Select top 5 = limit 5? By the way, HAVING is in your intermediate level, as far as I remember.

If you are going to use MYSQL then why did you let us install SSMS, The limit clause doesn't work in SQL server.

@gunnereshzurale8843

2 ай бұрын

Use TOP, same purpose

@taiebxr

3 күн бұрын

hello there are 2 courses in his channel you probably watch ssms one , otherwise in thsi course he asked us to isntall mysql