Finding biggest increase in MySQL

mysql sql

Solution 1:

"Biggest increase in salary" is ambiguous. You have found the biggest difference between the highest and lowest salaries. That is a very reasonable interpretation of the question, but there are others.

For instance, someone might have started at a high salary and then been demoted, so their highest salary is the first. This suggests another reasonable interpretation: the absolute value of the difference between the most recent salary and the first salary. That is a bit trickier to calculate in MySQL.

Another interpretation is the biggest percentage increase. So, an increase from $50,000 to $60,000 would be considered "bigger" than one from $500,000 to $550,000, because the percentage is bigger. Of course, this could be applied to either biggest/smallest or latest/first.

Similar questions could also have an answer regarding the increase per year in the salary.

So, the question is ambiguous, but you have a perfectly reasonable interpretation and your query implements this. I would not call the column max, because it is more appropriately called diff.

Related

Derivative of $\sec^{-1}x$ and integral of $\frac{1}{x\sqrt{x^2-1}}$
A concrete example of involution in group theory
Combinatorial identity $\sum_{k=0}^{n}\binom{n}{k}\binom{n}{k -1} = \binom{2n}{n+1}$
How to find determinant of the following $3\times 3$ matrix? [closed]
Deducing $\int_0^{\pi}\log \sin x dx =-\pi\log 2$ from $\int_0^{\pi}\log (-2ie^{ix}\sin x) dx = 0$
Is the limit $x \to - \infty$ of the cumulative distribution function always equal to $0$?
Show that $\beta $ is algebraic over $F(\alpha)$.
Deterministic Policy Gradient Theorem Proof
Question on Riemann Integrals
Prove trigonometric inequality $\sin x\leq 1-\left(\frac{2x}{\pi}-1\right)^2$
Finding the MLE of $P(x\leq y)$
How to solve $x e^x + x = 1$?