1. 学习
    2. /
  2. 课程
    3. /
  3. Exploratory Data Analysis in SQL
Connected

练习

Concatenate strings

House number (house_num) and street are in two separate columns in evanston311. Concatenate them together with concat() with a space in between the values.

说明

100 XP
  • Concatenate house_num, a space ' ', and street into a single value using the concat().
  • Use a trim function to remove any spaces from the start of the concatenated value.