UMGC Wk 8 Business Scenario Where You May Want to Use a Subquery Questions – Question Description
I’m working on a computer science multi-part question and need the explanation and answer to help me learn.
1. Describe a business scenario where you may want to use a set operator such as UNION or INTERSECT. Construct a query as your sample implementation. Can you achieve the same result without using set operator? What are some of the rules you’ll need to pay attention to when using set operators?
2. Describe a business scenario where you may want to use a subquery. Provide a sample query as your implementation. Are there alternatives without using a subquery? What are some of the advantages and disadvantages of using subqueries?
The post UMGC Wk 8 Business Scenario Where You May Want to Use a Subquery Questions first appeared on .
