You have an Azure Databricks workspace enabled for Unity Catalog that contains two Delta tables, Table1 and Table2, with the same data type. Table1 has a column named Column1. Table2 has a column named Column2. You execute the following query: ```sql SELECT Colum1 - FROM Table1 - GROUP BY Column1 - HAVING COUNT(*) > 1 - INTERSECT - SELECT Column2 - FROM Table2 - GROUP BY Column2 - HAVING COUNT(*) > 1; ``` What happens when the query is executed? SELECT Colum1 - FROM Table1 - GROUP BY Column1 - HAVING COUNT(*) > 1 - INTERSECT - SELECT Column2 - FROM Table2 - GROUP BY Column2 - HAVING COUNT(*) > 1;
`GROUP BY` with `HAVING COUNT(*) > 1` returns only values that occur more than once in each table. `INTERSECT` retains only rows common to both result sets, so the result contains values that appear more than once in both tables. Azure Databricks documents that only rows common to the two operands are returned by `INTERSECT`.