Question
Which SQL clause is used to filter rows based on a
specified condition *after* grouping has been performed?Solution
`HAVING`
- If a shopkeeper earns a profit on selling 30 metres of fabric equal to the cost price of 6 metres of the fabric, determine the profit percentage.
Zara purchased a microwave for Rs. 2400 and spent some amount on service. She marked it up by 25%, gave a Rs. 360 discount, and earned a 15% profit. Fin...
Oil equal to 20% of the weight of ground nut is extracted in a mill. The matter left after extraction is sold as cattle feed at the rate of Rs 12.5/kg. ...
A shopkeeper marked an article 60% above its cost price and made a profit of Rs. 297.6 when he sold the article after giving a discount of 22%. Find the...
A shopkeeper marked an article Rs. 800 above its cost price and sold it after giving a discount of 22% and earned a profit of 30%. Find the cost price o...
- If the total cost of 6 notebooks and 4 pencils is Rs. 240 and the total cost of 5 notebooks and 3 pencils is Rs. 195, then find the cost of 7 notebooks.
A marked an article 58% above the cost price and sold it for Rs. 268.6 after giving a discount of 15%. Find the percentage profit earned by him if he se...
A product is sold at 15% profit. If its cost price had been 25% lower, and it was sold at a 30% loss, the seller would have made Rs. 280 less. What was ...
A trader sold 15 kg of wheat and suffered a loss equal to the selling price of 5 kg of wheat. If the total purchase price was Rs. 480, find the selling ...
A machine is sold at an 8% profit, making its selling price Rs. 63 higher than the selling price if it were sold at a 20% loss. W...
