Question
Which SQL keyword is used to modify existing rows in a
table?Solution
UPDATE
The average weight of 4 persons is 44 kg. The heaviest person’s weight is 30 kg more than the lightest person’s weight. If the average weight of the...
The average marks obtained by 6 students in a class is 60. If the topper leaves, the average drops to 55. Find the marks of the topper.
The average age of a group of 8 friends is 30 years. If one of them leaves, the average becomes 29. Find the age of the friend who left.
Find the median of the following observation:
24, 28, 29, 21, 19, 18, 25, 27, 17, 20, 28, 30, 11, 13The average number of books on history, polity and geography in a library is 140, and the average number of books on history and geography is 150. If th...
A school bought 45 benches and 55 desks. Average cost of a bench is Rs. 1,800 and that of a desk is Rs. 2,700. Find the average cost (in Rs.) of all the...
The average weight of a family of 5 members is 60 kg. If the youngest member dies, the average weight of the family decreases by 2 kg. Find the weight o...
In a classroom of 45 students, the average height is 150 cm. One student of height 146 cm leaves, and 3 new students with an average height of 154 cm jo...
- Three numbers are given such that when the average of any two numbers is added to the third number, the resulting sums are 250, 240, and 230. Determine the...
Average of 8 numbers is 80. If average of first four and last two numbers is 70 and 60, respectively then find the fifth number given that ratio of fift...
Relevant for Exams:
