1. 学习
  2. /
  3. 课程
  4. /
  5. Intermediate Importing Data in R

Connected

练习

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.

说明

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.