1. Learn
    2. /
  2. Courses
    3. /
  3. Intermediate Importing Data in R

Exercise

Query tweater (4)

There are also dedicated SQL functions that you can use in the WHERE clause of an SQL query. For example, CHAR_LENGTH() returns the number of characters in a string.

Instructions

100 XP
  • Create a data frame, short, that selects the id and name columns from the users table where the number of characters in the name is strictly less than 5.
  • Print short.