question archive I have to write a query which shows the common last names of any individuals in both tables
Subject:Computer SciencePrice: Bought3
I have to write a query which shows the common last names of any individuals in both
tables. Make sure you ignore case (Smith=SMITH=smith). Make sure duplicates
are removed. Alphabetically order the results and also wrie a query which shows the employee IDs that are unique to the employee table. Order the employee IDs in descending order. An employee ID Is the same
in both tables if the integer value of the ID matches.