Question
Which SQL clause is used to filter rows based on a
specified condition *after* grouping has been performed?Solution
`HAVING`
Ram gave a discount of 20% on the marked price of an item and still gained 10.4%. How much would have Ram gained, if he sold the item at the marked price?
What is the single percentage discount equivalent to two successive discounts of 15% and 5%?
Successive discounts of 20, 25 and 30% is equivalent to a single discount ofÂ
A hotel is giving a discount of 12% on the booking of 2 or more rooms. Additionally, the hotel is offering a 5% discount only on payment using any card ...
The selling price of an article is Rs 816 if the discount on it is 15%. What would be the selling price of the article (in Rs) if the discount on it is...
Two successive discounts of 20% and 10% are equal to what single discount percentage?
A shopkeeper sold an article for Rs. 840 after giving a discount of 20%. What was the marked price of the article?
A chair is sold for Rs810 after giving a discount of 10% on its marked price. The cost price of the chair is Rs720. If it is sold at the marked price, t...
An article is marked 40% above the cost price. If a discount of x% is given on the marked price of the article, then a final profit of 12% is obtained. ...
A shopkeeper sells an item at ₹1500 which is marked as ₹2000. What is the discount he is offering? Â
