Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
An overview of the Simple WHERE Clauses with SQL reports you need to generate.
Course
Workshop
Resources
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
[MUSIC]
0:00
Hello world Andrew here,
database user, life longer learner and
0:04
teacher here at Treehouse.
0:07
Here's another practice session for you.
0:09
Practice helps you make what
you've learned last longer.
0:13
These practice sessions help you
on your road to SQL mastery,
0:15
you'll be more confident and
a better analyst or developer.
0:19
Let's practice some basic SQL to
make sure your knowledge sticks.
0:22
This practice session covers SQL queries
with simple WHERE clauses, with comparison
0:26
operators, such as equality, and
inequality, and relational operators.
0:31
You'll also be tasked with
writing queries with ranges and
0:36
filters with sets of values.
0:39
This practice session is
intended to be a followup for
0:42
the third section of
this SQL basics course.
0:45
If you haven't taken that course yet or
0:47
if you found this practice session too
difficult, then take SQL basics first and
0:49
then take the other practice
session before this one.
0:54
In the teacher's notes I've
added a link for the course and
0:58
the other practice session.
1:01
Launch the SQL playground with this video,
this SQL playground is for
1:02
an online retailer.
1:06
There are three tables, a customers table
containing all customers of our retailer,
1:07
a products table that contains a list
of all products that are available.
1:13
And a sales table containing
all the sales entries.
1:17
Pause this video and familiarize yourself
with the tables and their contents.
1:21
There are several coding areas
here on the left hand side.
1:27
Each of the coding areas
have a particular challenge.
1:31
Challenge one is to get all
mailing information for
1:34
orders that have taken
place on the 20th of April.
1:37
Challenge two is to retrieve name and
1:40
pricing information on all
Playstation four models.
1:42
Think of three possible
ways you could do this, and
1:46
then think about which way would be best.
1:49
Challenge three is to get
the mailing address for
1:52
customers without email addresses.
1:54
This is so
we can send coupons via snail mail.
1:56
Challenge four is the opposite to
get a list of email addresses for
2:00
customers with an email address present.
2:04
Then we can email them coupons.
2:07
Challenge five is to check what products
that we have in surplus in our warehouse.
2:09
That way we can run promotions on those
products to clear some space to make way
2:13
for newer products.
2:17
Challenge six is to search for all orders
with totals between $225 and $245.
2:18
The final challenge is to find
all products with 4k support.
2:25
I've included a link to the SQL
cheat sheet in the teacher's notes.
2:29
But try to see if you can do it
without refreshing your memory
2:34
It's okay to try a couple of different
queries before you get the right query.
2:37
If you're stuck and need some
reference you can use the cheat sheet.
2:41
But try and do it without it first.
2:45
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up