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 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
• Two vessels contain mixtures of milk and water in the ratio of 8 : 1 and 1 : 5 respectively. The content of both of these are mixed in a specific ratio into a third vessel. How much mixture must be drawn from the second vessel to fill the third vessel (ca