datacamp-logo
Course Outline
Exercise

More selections

Now that you've practiced how to select one column at a time, it's time to practice selecting more than one column. You'll continue working with the eurovision table.

Instructions 1/3
XP
  • 1

    SELECT the country and event_year columns from the eurovision table.

      Take Hint (-10 XP)
  • 2

    Use a shortcut to amend the current query, returning ALL rows from ALL columns in the table.

  • 3

    Return all columns, but only include the top half of the table - in other words, return 50 percent of the rows.