1. Learn
  2. /
  3. Courses
  4. /
  5. Introduction to SQL Server

Connected

Exercise

Where

You won't usually want to retrieve every row in your database. You'll have specific information you need in order to answer questions from your boss or colleagues.

The WHERE clause is essential for selecting, updating (and deleting!) data from your tables. You'll continue working with the grid dataset for this exercise.

Instructions

100 XP
  • Select the description and event_year columns.
  • Return rows WHERE the description is 'Vandalism'.