Question
A town's population increased by 5% in the first year,
increased by 15% in the second year, and decreased by 9% in the third year. If the population in 2023 was 24,063, find its population in 2020.Solution
Let the population in 2020 be 'x'. ATQ, x × 1.05 × 1.15 × 0.91 = 24063. Or, x = 24063 / (1.05 × 1.15 × 0.91). Calculating further, x ≈ 21823. Therefore, the population of the town in 2020 = x = 21823.
Which SQL clause is used to filter results after a GROUP BY operation?
Which SQL clause is used to group rows?
What is an SQL `VIEW`?
Which SQL keyword prevents duplicate rows in result?
Which SQL command is used to remove a table completely?
Which clause is used to sort query results in SQL?
Which SQL operator is used to search for a pattern in a column?
Which of the following statements about SQL `INDEXES` is generally TRUE?
Which join returns rows from the left table even when there is no matching row in the right table, filling with NULLs for the right side?
What is an SQL `VIEW`?
