Start learning 50% faster. Sign in now
Explanation:- The SUM( ) function is the correct choice because it calculates the total sum of a numeric column , such as total sales revenue. In a sales database, the amount column typically stores transaction values. To get the total revenue from completed transactions , we use SUM( ) on the amount column while filtering only completed orders. This ensures that the final result represents the overall revenue generated from valid transactions. For example, if completed transactions have amounts 500, 1000, and 1500 , SUM( ) will return 3000 , which is the total revenue .
The average income of 'Pawan', 'Qureshi,' and 'Ranjan' is Rs. 'y', and their incomes are in the ratio of 5:3:4, respectively. 'Pa...
A person purchased diesel at Rs. 7, Rs. 10 and Rs. 12 per litre in three successive years. If he spent Rs. 2520 each year on diesel, then find the appro...
The average of 12, 33, and x is 25. What is the value of x?
The average number of books sold by Viren in first 5 months is 3800 and in first 6 months is 4600. If the number of books sold by him in 7th ...
The average age of a group of persons going for tour to Shimla is 22 years. 30 new persons with an average age of 8 years join the group and their avera...
The average weight of 7 men decreases by 3 kg when one of them weighing 150 kg is replaced by another person. Find the weight of the new person
Average age of a class of 33 students is 14 years. Average age of the class is increased by 18 months if the age of the teacher is included. Find the ag...
Find the average of five numbers a, b, c, d and e such that b = 20, and a is 20% more than that of ‘b’. ‘c’ is 10 less than &ls...
The average selling price of rice is Rs. 5 per kg more than the average selling price of pulses. The quantity of pulses sold is 25% more than the quanti...
The average age of three children is 20 years. If their ages are in the ratio 5:6:9. Find the age of the youngest child.