Answer:
The query may still be specified in SQL by using a nested query as follows (not all
implementations may support this type of query):
SELECT DNAME, COUNT (*)
FROM DEPARTMENT, EMPLOYEE
WHERE DNUMBER=DNO AND SEX='M' AND DNO IN ( SELECT DNO
FROM EMPLOYEE
GROUP BY DNO
HAVING AVG (SALARY) > 30000 )
GROUP BY DNAME;
Explanation:
To answer this item, we assume that the interest rate is simple, such that the yearly rate was only divided by 12 months in order to determine the rate per month. Hence, to answer this item, we simply have to multiply the given percent by 12.
rate of interest/year = (12)(0.85%) = 10.2%
Therefore, the answer is 10.2%.
6.29% is the rate of growth
<u>Explanation:</u>
<u>The following formula is used
</u>
Price = D1 / ke -g
39.86 = 1.2 multiply with (1 + g) / 0.095 - g
3.7867 – 39.86 g = 1.2 + 1.2 g
2.5867 = 41.06 g
Now, we have to calculate the value of g
g = 2.5867 divide 41.06
= 0.0629
= 6.29 %
Where:
G = growth, ke = market rate of return, D1 = dividend ( annual), P = price of the share of company
<span>Corruption is stealing of funds that are not supposedly owned by the stealer. In most cases, it mostly happening in institutions and organizations. People are hesitant to report corruption because (1) they would be ‘silenced’ (killed) by the person they are trying to expose or (2) they are part of the dirty job.</span>
