Question
What is the purpose of the "GROUP BY" clause in an SQL
query?Solution
It groups the rows based on specified columns.
- The current average age of X, Y and Z is 35 years. Three times the current age of Y is 60 more than twice the current age of X. If the age of Z after 10 ye...
A is younger than B by 3 years. If the ratio of A and B ages is 12:13 respectively, then find the age of A.
Present ages of P and Q are in the ratio 2:5 respectively. If Q’s age, 15 years hence from now will be 5 times of P’s age, 5 years ago from now, the...
At a family event, the present ages of Mira and Junaid are in the ratio of 2:5. Moreover, Imran is 7 years younger than Mira. Twelve years ago, Imran's ...
The ratio of present ages of Riya to Meera is 5:4. The sum of their ages after 8 years will be 68 years. If the age of Tanya is 3 years more than 4 time...
Present ages of P and Q are in the ratio 5:8 respectively. If Q’s age, 14 years hence from now will be 4 times of P’s age, 4 years ago from now, the...
Present ages of ‘K’ and ‘L’ are in the ratio 14:6, respectively. If ‘t’ years hence from now, ‘K’ will be twice as old as ‘L’, then ...
The ratio of A and B present age is 8:5. The product of their ages is 4000. What will be the ratio of their ages after 5 years?
Present ages of ‘A’, ‘B’ and ‘C’ are in the ratio 12:13:16, respectively. If present average age of ‘A’ and ‘C’ is 28 years, then fi...
"Amit and Bishnu's current ages are in the ratio 4:5. Chintu's age is 40% more than Amit's age. If Bishnu and Chintu's ages sum up to 106 years, what is...
Relevant for Exams:
