Question
Which SQL clause is used for filtering
rows?Solution
WHERE filters rows before grouping. HAVING filters groups.
In 6 years, Divya's age will be 40% less than Malu's age at that time, and currently, Divya's age is 25% more than Soni's age. Additionally, the age of ...
In a classroom there are 15 boys and 13 girls. Average age of each boy and each girl is 21 years and 17 years respectively. The sum of ages of all the b...
A boy’s age is 150% of what it was 5 years ago, but 75% of what it will be after 8 years. What is his present age?
The average age of A, B and C is 40 years, while the average age of B, A and D is 30 years. If the ratio of the age of C and D is 5:3, respectively, the...
Present ages of P and Q are in the ratio 5:7 respectively. If Q’s age, 11 years hence from now will be 5 times of P’s age, 5 years ago from now, the...
- Four years ago, the ratio of ages of 'X' and 'Y' was 2:3 respectively. Six years from now, the ratio of their ages will become 4:5 respectively. If 'Z' is ...
The present ages of a father and his son are such that 10 years ago, the father was 3 times as old as his son. Eight years from now, the father will be ...
The present age of a father is three times that of his son. After 10 years, the father’s age will be twice that of his son. What are their current age...
Amit age after 20 years will be 4 times his age 4 years back. What is the present age of Amit?
Five years ago, the average age of a family of four members was 25 years. Six years hence, the ratio of their ages will be 9:7:5:3. Find the a...
