Answer:
Give at least one reason why it's useful to learn how to solve and program solutions with a limited set of commands. So that when there is more commands we know how to use the ones we have. parameters help generalize the solution to a specific problem. how are functions with parameters an example of abstraction?
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
Answer:
The algorithm is as follows
1. Start
2. Input Apple unit price
3. Input Mango unit price
4. input Tomato unit price
5. Total = Apple Price * 2 + Mango Price * 2 + Tomato Price
6. Display Total
7. End
Explanation:
Start the algorithm
1. Start
The next three lines gets input for the price of each fruit
<em>2. Input Apple unit price</em>
<em>3. Input Mango unit price</em>
<em>4. input Tomato unit price</em>
This calculates the total price
5. Total = Apple Price * 2 + Mango Price * 2 + Tomato Price
This displays the total price
6. Display Total
Stop the algorithm
7. End
