You are not logged in.
Pages:: 1
#1 2015-09-18 06:16:43
SQL Quiz Question.
Database Quizzes SQL
Question:
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF.
Option A):
SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;
Option B):
SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;
Option C):
SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;
Correct Answer is Option B):
SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;
You cannot discover the new oceans unless you have the courage to lose the sight of the shore.
Offline
2015-09-18 06:16:43
- Advertisement
- Ads By Google
Re: SQL Quiz Question.
\n
Pages:: 1