Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Practice Simple WHERE Clauses with SQL!
You have completed Practice Simple WHERE Clauses with SQL!
Preview
Here are some examples of ways to solve the challenges.
Please Provide Feedback
We’re looking for feedback on this new type of practice workshop. When you’re finished, could you please review the workshop by filling out this short form?
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
Compare them with your SQL statements.
0:00
It doesn't matter if
they're slightly different.
0:00
Often there are number of
ways to do same thing in SQL.
0:01
Challenge one was to get the sales from
April the 20th to create mailing labels.
0:05
I selected the customer name,
delivery address from the sales table.
0:10
In the where clause I used
the equality operator.
0:14
Challenge two was to select
all Playstation 4 models.
0:18
I asked you to think of three
possible ways you could do it, and
0:23
think about which way would be the best.
0:26
You can start with the equality operator,
with the OR keyword,
0:28
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