Answer:
WITH deptsalary AS (
SELECT dept, SUM(salary)
FROM emp
GROUP BY dept)
SELCT *
FROM deptsalary
Explanation:
deptsalary is temporary table.
dept and its respective sum of salary is to be displayed
<h2>this is a PICTURE </h2>
<h3>i HOPE IT'S HELP </h3>
Question 1: Best way is option 1, Worst way is option 4.
Question 2: Best way is option 4, Worst way is option 3
The baby boomers is a type of demographic group. The demographic groups are usually categorized by age, income bracket, social class and so on. Baby boomers are classified as a generation of a group of people and also therefore, by their age range.