If you want to add another row (i.e., offer a second promotion) to the qualifying people, do something like thisINSERT INTO tbl(CustID, Age, Soup, Meat, Fish, Sweet, Fruit, PromotionToOffer)SELECT CustId, Age, Soup, Meat, Fish, Sweet, Fruit, 'Campaign-B' AS PromotionToOfferWHERE Age > 20 AND Fruit > 15;
If you want to replace such people's offer with Campaign-B, then use update as shown belowUPDATE tbl SET PromotionToOffer = 'Campaign-B'WHERE Age > 20 AND Fruit > 15;