DataCamp
Course Outline

Intersect

100xp

Repeat the previous UNION ALL exercise, this time looking at the records in common for country code and year for the economies and populations tables.

Instructions

  • Again, order by code and then by year, both in ascending order.
  • Note the number of records here (given at the bottom of query result) compared to the similar UNION ALL query result (814 records).
    Take Hint (-30xp)