1. Học hỏi
    2. /
  2. Dự An
    3. /
  3. Data-Driven Decision Making in SQL
Connected

Bài tập

Join renting and customers

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

Hướng dẫn 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.