Question
Which SQL clause is used to filter records based on
aggregate functions?Solution
HAVING filters groups after aggregation, unlike WHERE which filters rows before aggregation.
The ratio of cost price and selling price of a shirt is 4:5 respectively. The shirt was marked up by 30% above its cost price, and sold after giving Rs....
- A vendor made a profit of 22% on an article, while another vendor sold the same article for a 19% profit. If the first vendor’s profit was Rs. 45 more th...
A shopkeeper purchased an article for Rs. ‘a’ and marked it 140% above its cost price and sold it after giving two successive discounts of Rs270 a...
'A' purchased an article and sold it to 'B' at 10% profit. 'B' marked it up by 20% above the price at which 'A' has purchased it and then sold it after ...
A shopkeeper marks an article 50% above the cost price and allows a discount of 20%. If the cost price of the article is ₹600, find the selling price.
- Priya purchased a piece of jewelry and marked its price 50% higher than the cost price. She sold it after giving a 20% discount for Rs. 4800. What would be...
A person bought an article and sold it at a loss of 25%. If he had bought it at 20% less and sold it for 63 more, he would have gained 20%. Find the pro...
The selling price of an item rises by Rs. 50 when the profit percentage is increased from 20% to 30%. What is the cost price of the item?
A purse is sold for 12/25 of its marked price, yielding a profit of 20%. What is the ratio of the marked price to the cost price?
A shopkeeper marked an article P% above its cost price and sold it for Rs. 748.8 after giving a discount of 28%. If the shopkeeper had a loss of 6.4% on...
