products$\_$a Table

$\backslash$table$[[$product id$,$product name,price$],[1,$Laptop,$1000],[2,$Mouse,$20],[3,$Keyboard,$50],[$products$\_$b Table,product$\_$name,$],[$product$\_$id$,$Moritor,price$],[4,$Printer,$200],[5,$Keyboard,$150],[3,,50]]$

Which query correctly combines all unique rows from both tables into a single result set?

SELECT product$\_$id$,$ product$\_$name, price FROM products$\_$a UNION ALL SELECT product$\_$id$,$ product$\_$name, price FROM products$\_$b:

SELECT product$\_$id$,$ product$\_$name, price FROM products$\_$a UNION SELECT product$\_$id$,$ product$\_$name, price FROM products$\_$b:

SELECT product$\_$id$,$ product$\_$name, price FROM products$\_$a JOIN products$\_$b USING $($product$\_$id$,$ product$\_$name, price$)$:

SELECT DISTINCT product$\_$id$,$ product$\_$name, price FROM $($ SELECT product$\_$id$,$ product$\_$name, price FROM products$\_$a UNION SELECT product$\_$id$,$ product$\_$name, price FROM products$\_$b$)$ AS combined$\_$products: