This is for SQL. Show a union that uses more than two select statements. The following select statement shows the number of lunches that each employee will attend, but it does not account for Carol Rose or Paula Jacobs because they are not attending any lunches. Modify this statement to show that these two people will not attend any lunches. select a.first_name,                a.last_name,                count(b.lunch_id) as number_of_lunches from l_employees a            inner join l_lunches b            on a.employee_id = b.employee_id group by a.first_name,                     a.last_name;

This is for SQL. Show a union that uses more than two select statements. The following select statement shows the number of lunches that each employee will attend, but it does not account for Carol Rose or Paula Jacobs because they are not attending any lunches. Modify this statement to show that these two people will not attend any lunches.

select a.first_name,
               a.last_name,
               count(b.lunch_id) as number_of_lunches
from l_employees a
           inner join l_lunches b
           on a.employee_id = b.employee_id
group by a.first_name,
                    a.last_name;