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

Connected

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.