Think the output shown in video for "WHERE NOT EXISTS" is incorrect. It should fetch 2 values instead of 1. It should be "Magical Products" and "Amazing Stuff" as both of them have items less than 1 $

How to apply

What if we need column name , instead of aggregates ?

Kindly help me understand what data types did you use

video is good but background music is so annoying.

That was quite helpful, thank you so much, but would you mind turn off the background music, it's distracting, I can barely hear your voice.

Please remove background music, hard to focus on what you're saying. Otherwise, great video!

Hello, I recently purchased the $90 lifetime access course package. I lost my login credentials and have been locked out of my account. A password reset is not working. Can someone please help me get access to my account. Thanks.

thank u

Hi, where could i find the solution for the common error you described at 3:35 (=Common mistake #2) ?

Your videos are really very helpful to me to learn SQL with great explanation, thank you a lot.

The result in 2:12 only should have one column "ID". Learn yourself sql before teaching.

This book could help ... Data Science and Engineering - A learning path - Volume 4 Relational and non-relational databases and SQL: with applications in MySQL, SQLite and Orange Data Mining

This book could help ... Data Science and Engineering - A learning path - Volume 4 Relational and non-relational databases and SQL: with applications in MySQL, SQLite and Orange Data Mining

ر

that was good

Absolute brilliant example and explanation. Thank you!!!

Good overview. Thanks. I'd like to add one thing to keep in mind. It seems easy to consider this and use is null instead. However the pitfall is, when you compare against a column value (e.g. in a join), where null values exist. Or when you use optional user inputs and try something like this: tbl.col = NVL({input}, tbl.col) When this columns contains nulls then this becomes tbl.col = null what fails. (Here the solution could be tbl.col = {input} or {input} is null) The danger is, when you get a good looking resultset and don't recognize, that you compare against null!

Your videos are great. Not sure why included this background music. You just ruined your efforts.

Thank you, Adrian! Your videos are short and sweet. Worth them to watch. Really loved them. Thanks!

do we get a solution and explanation for practice problems?

I'm really trying to listen to you but the music is so annoying...

Excellent explanations, now I'm your subscriber.😊

Please : get RID OF THE MUSIC..can hardly hear you

AARGH.......whats with the super intrusive music? overshadows what you're saying. NOt watching anymore.

Good video - but please ditch the annoying background music

Yes, on my way!!

Raise the music so we can’t hear you ❤

What will happen if we put reverse in subquery City. Countryid = bigCity.CountryID? Is this same?

Hi How to join this course?

Teşekkürler dostum

Quick and to the point !

Good video. But you may consider to reduce the background sound or drop it altogether. Thanks. Good job tho. Peace

is't better use distinct in subquery? `SELECT * FROM city WHERE id IN (SELECT DISTINCT city_id FROM university WHERE rank <= 100);`

You should try and find people to interview who have learned SQL and how it has helped their career!

Just wanted to get a brush up on some SQL topics, and your video was really helpful. But please, please do not put music on such a lecture video. It is really disturbing the purpose of the instructor, most of the words were not audible.

Thank you so much. I finally understood how they work 🥺

What an amazing explanation! Congrats from Brazil.

Thank you for the explanation but please can you reduce the background sound in subsequent videos, it was overshadowing your voice and was quite distracting. Thanks again

Thank you, I was confused about this for a bit. You video really cleared this up!

Brilliant thank you

Really clear videos, great stuff

(This course is very technical to listen in english (because i'm french) it looks very interesting but really the music in the background is really disturbing .. i can't listen)

Thanks

I couldn't still get it. So , what is the real function of this exists though? If we, let's say remove it from your query sample, what will be fundamentally changed in the result set?

Great video! I just want to add that subqueries in the select statement are also referred to as 'subselects' and that a subselect query can reference columns in the select query. However, subqueries used in join cannot. Queries used in joins can also have multiple columns and are similar to a common table expressions (CTE). In SQL the only parts you need single-row unique columns are in: subselects and in where clause subqueries.

thank you for this amazing explanation but the first one we can do like this select * from students where age > (select min (age ) from lecturer);

Music is bothering...

Q1: Is there any student older than all lecturers in the university? Q2: Is there any lecturer who is younger than all students?

ARE U HEISENBERG?