Overlap and difference: INTERSECT and EXCEPT · exercise 1 of 1 · free preview
query1 INTERSECT query2 returns only the rows that appear in both results, without duplicates. Both queries need the same number of columns, with compatible types.
List the names of the products that were sold in online orders and also in counter orders. Use INTERSECT. Order by name.
Tables in this practice shop
customersproductsordersorder_items