$1.$ What is wrong with this select statement?

select number$\_2$

from twos

union

select number$\_3,$

word$\_3$

from threes;

Answer:

$2.$ Goal $1$: Show that a union is similar to an insert statement in that it can add new data to the result table.

Answer:

$3.$ Goal $2$: 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;