Question
In SQL, which aggregate function is most appropriate for
calculating the total revenue from completed transactions in a sales database?Solution
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 . Â
An angle is equal to 3/7 of its supplement. The angle is :
In ∆ABC, AD = DB , DE is parallel to BC, and the area of ∆ABC is 20 cm2. What is the area of ∆ADE in cm2 ?
The ratio of the angles ∠A and ∠B of a non-square rhombus ABCD is 7:5, then the value of the ∠C is
In ∆ABC , G is the centroid , AB = 18 cm, BC= 24 cm and AC = 30 cm , find GD, where D is the mid-point of BC?
The length of the each side of an equilateral triangle is 42√3. The area of incircle, (cm 2 ) is
The radius of the incircle of a triangle is 6 cm. if the area of the triangle is 30 cm 2 , then its perimeter is?
In the given figure, B and C are the centres of the two circles. ADE is the common tangent to the two circles. If the ratio of the radius of both the ci...
Find the ratio between the area of the in-circle and the circum-circle of a square?
In ∆ABC , G is the centroid , AB = 20 cm, BC= 24 cm and AC = 28 cm , find GD, where D is the mid-point of BC?
If the area of ∆ ABC is 30 cm2 & G is the centroid of ∆ ABC.then the area of the ∆ AGB?
