Learn SQL Programming - 2 - Filter Queries With WHERE

Enroll for exercises, tutorials, courses, and projects...

Let's learn about SQL queries and how they work! We are gonna focus on the WHERE query as that is really important and super awesome!

Enroll in Learn Python™ course

==================================================
Connect With Me!

Snapchat ► Rafeh1

[intyinty]

l have learned SQL from many so-called expert youtuber, but I am still confused and spending lots of time to set up SQL environment. But here you go! the way you teach is so clean and neat! love it ! keeep it up!
BTW, i was your fan since you had 300 fans. haha.

[denismurphy]

Nice video! For the last problem I went with:

SELECT * FROM movies WHERE ID BETWEEN 1 AND 5;

[latricejones]

Just found your videos and I must say you make this so easy. I wanted to refresh on some totally will be a subbie now!!

[richb]

--Easier solution since it's sorted Ascending
SELECT Title, Year FROM movies
where Id < 6; or (<= 5)
--This encapsulates everything already covered!

[parerisimeme]

for the first 5 movies, i would type :

select * from movies limit 5;

[myni-intuit]

Trying to learn SQL, for the last task I entered:

SELECT title, year
FROM movies

where id <= 5
I passed!! On to #3 :)

[siljehelenewaagaard]

This is brilliant! I’m going to watch a LOT of your videos!

[travelwithus]

Really it helped me a lot in learning SQL in a very easiest way ever thanks man

[ajayshenoy]

Your last problem approach is correct only when you know and you can see the table. If it were me, I would use this query which would work even if the year is not sorted and you cannot see the table.
Select Top 5 title, year
From Movies
OR
Select title, year
From Movies
Limit 5

[stephenmandelbaum]

for the 3rd challenge I put the following and got credited for passing:
SELECT *
FROM movies
where year not between 2000 and 2010;

Is your way more correct, or is there more than one solution?

[syedjahangirali]

Hey qazi the site you mentioned in description (SQL bolt) contain total coures. Or can you suggest any good free website to learn SQL as i am a biggener.

[MrHanSoL]

Keep up the good work man, you're a good teacher!

[TheNoiseySpectator]

For the third line of #3, at about 9:54,  would this have worked?    

WHERE NOT year FROM 2000 TO 2010 ;            
Instead of "BETWEEN & AND"?

What would it have done?

[soby]

i have found the first 5 movies like this:

SELECT Title, YEAR FROM movies
WHERE year BETWEEN 1995 AND 2003

[mattiekahn]

I'm trying to find out how to filter using a concatenated string such a person's name-- this is what I used --AND etk_person.first_name + ' ' + etk_person.last_name = 'Susan Smith', there were other filters but this one isn't working-what am I doing wrong?  Can you possibly help?  Thanks!

[filipthedev]

12:37 for me it worked with id s "between" and "and"

[shivaniverma]

u help us so nicely
have a good day qazi

[akhil]

Why Facebook doesn't use Sql with python

[MrStreamZ]

I done it like

SELECT *
FROM movies
where year between 1995 and 2003;

[Zen-rwfz]

year < 2004 looks cheap
what am I supposed to do when I don't know the year of the movies?