You are not logged in.

#1 2015-09-18 06:16:46

hasnain
Administrator
From: Chichawatni
Registered: 2014-10-13
Posts: 8,355
Website

SQL Quiz Question.

http://interviewquestionsanswers.org/quiz/Database http://interviewquestionsanswers.org/qu … L-Database

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;


Failure is the first step towards seccess.

2015-09-18 06:16:46

Advertisement
Ads By Google

Re: SQL Quiz Question.



Board footer