1. 学习
    2. /
  2. 项目
    3. /
  3. Data-Driven Decision Making in SQL
Connected

练习

Join renting and customers

For many analyses it is necessary to add customer information to the data in the table renting.

说明 1 / 共 3 个

undefined XP
    1
    2
    3
  • Augment the table renting with all columns from the table customers with a LEFT JOIN.
  • Use as alias' for the tables r and c respectively.