Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF.

A).  SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;

B).  SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;

C).  SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;

D).  SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;

Option C

SELECT city, temperature, condition FROM weather
WHERE (condition = 'sunny' OR condition = 'cloudy')
AND temperature > 70;

• A @ B means `A is not smaller than B? A # B means ?A is neither smaller than nor equal to B? A % B means ?A is neither smaller than nor greater than B? A $ B means ?A is not greater than B? A * B means ?A is neither greater than nor equal to B?
• Nidhi received simple interest off Rs. 1200 when invested Rs x at 6% p.a. and Rs y at 5% p.a. for 1 year. Had she invested Rs. x at 3% p.a. and Rs. y at 8% for that year, she would have received simple interest of Rs 1,260. Find the values Rs. x an y.
• The letters A, B, C, D, E, F and G not necessarily in that order, stand for seven consecutive integers from 1 to 10, D is 3 less than A, B is the middle term. F is as much less than B as C is greater than D, G is greater than F.
• A vessel contains 20 litres of acid. 4 litres of acid is taken out of the vessel and replaced by the same quantity of water. Next 4 litres of the mixture are with, drawn, and again the vessel is filled with the same quantity add left in the vessel with t
• A shopkeeper buys a blanket at a discount of 20% on the listed price from a wholesaler. The shopkeeper marks up the price by 15% on the listed price. A buyer pays Rs. 3795 to get it after paying sales tax rate of 10% on the price asked for. Find the profi