Why do my queries involving Cartesian product run slowly

brickster_2018
Databricks Employee
Databricks Employee