M

Mr. Dubey • 100.69K Points
Coach

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

  • (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
Share

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs

Q. Need hierarchy theory of motivation has been given by

Q. ___________ This module gets data from sub-ordinates and forward it to superordinate(boss) modules.

Q. …………. is an activity oriented diagram.

Q. ————– pattern describes a collection of distributed components that provide and/or consume the services.

Q. Which of the following statement is valid?

Q. Which scheduling algorithm allocates the CPU first to the process that requests the CPU first?

Q. Direction is a ________ function performed by all the managers at all levels of the organization.

Q. Consider the regular language L = (111+111111)*. The minimum number of states inany DFA accepting this language is

Q. The effective address of the instruction written in Post-indexed mode, MOVE[Rn]+Rm is

Q. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

Question analytics