Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . What is wrong with this select statement? select number _ 2 from twos union select number _ 3 , word _ 3 from
What is wrong with this select statement?
select number
from twos
union
select number
word
from threes;
Answer:
Goal : Show that a union is similar to an insert statement in that it can add new data to the result table.
Answer:
Goal : 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 afirstname,
alastname,
countblunchid as numberoflunches
from LEMPLOYEES a
inner join LLUNCHES b
on aemployeeid bemployeeid
group by afirstname,
alastname;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started