WHERE explained
Congratulations guys! You've just scored a date with the girl of your dreams. Problem is, all your shirts are raggedy and old. You need a desperate upgrade before making a first impression on your date.
So, you hop online and go to CoolGuyShirts.com to find the perfect fit. You browse through the 6 shirt options and notice a filter on the left-hand side.
You'll utilize this filter to quickly determine what shirt you want to buy. First things first, you only want a shirt if it's got a 4-Star & Up rating. You need some high-class stuff!
Next, you know you look good in red. So, you select the option to only see red shirts.
But then you realize that blue might look good with your pants. So, you select that option as well.
Perfect, now we've got 2 options to choose from.
In this situation, we utilized the filter to select 4-Star & Up shirts that are red or blue. We also essentially preformed a WHERE statement.
We took all of the shirts and defined conditions that each shirt must fit in order to be shown in the results.
WHERE statements are used to define conditions that each record must fit to be shown in the results.
How to code a WHERE
Here is the template for WHERE statements:
PAID CONTENT This is the end of the preview. To unlock the rest, get the SQL Cram Kit or Lifetime Access.
Already purchased? Click here to log in.
I’m a Miami University (OH) 2021 alumni who majored in Information Systems. At Miami, I tutored students in Python, SQL, JavaScript, and HTML for 2+ years. I’m a huge fantasy football fan, Marvel nerd, and love hanging out with my friends here in Chicago where I currently reside.