7. What is the SQL UNION command and when is it useful?
The UNION command combines matching rows of data from two tables. The basic version of the command automatically eliminates duplicate rows of data.