WHERE | BUS 104 – SQL Exam

Video is available upon purchase of SQL Cram Kit, Lifetime Access or BUS 104 Cram Kit Bundle

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:


This is the end of the preview. To unlock the rest, get the SQL Cram Kit, Lifetime Access or BUS 104 Cram Kit Bundle.

Already purchased? Click here to log in.

Leave a Comment