Select the partition each row belongs to$.$PARTITION BY LIST $($Continent$)($

PARTITION p$1$ VALUES IN $(\text{'}$EU$\text{'}),$

PARTITION p$2$ VALUES IN $(\text{'}$NA$\text{'},\text{'}$SA$\text{'},\text{'}$AS$\text{'}),$

PARTITION p$3$ VALUES IN $(\text{'}$OC$\text{'},\text{'}$AF$\text{'})$