01

UNION and JOIN

Union allows us to combine the values of columns of different tables together as long as they are of the same value type

10-01-06

Find money spent and earned by company

select 'operating cost', SUM(salary)
from employee
UNION
select 'total sales' , SUM(total_sales)
from works_with;