Intersect and Except in BigQuery

Almost everyone working with SQL has used UNION and UNION ALL. But these are not the only set operations available in SQL. Meet INTERSECT and EXCEPT. What do they do? As the name suggests they perform the following set operations: INTERSECT returns ...