Skip to content
Advertisement

Tag: databricks-sql

How to join two total tables using sql?

For a university work we have two tables in sql: table1: table2: I need to join the two tables by adding the total number of people in each city. So I tried to do: However, if a city A appears in table 1 and does not appear in table 2 this would not work. The same would happen if a

Advertisement