I have a question about a query to be done in MySQL Here is he table I need to u

Question

I have a question about a query to be done in MySQL

Here is he table I need to use for the question called 'likes':

The question is

I am expecting the answer to be empty but I need to SQL query itself.

likes drinker beer John Blue Moon Mike Blue Moon John Bud Mike Bud Vince Bud John Budweiser Mike Budweiser John Creamy Dark Mike Creamy Dark Joe Hefeweizen Mike Hefeweizen John Killian's John Michelob Golden Draft Mike Michelob Golden Draft Light John Original Premium Mike Original Premium Lager Jesse Original Premium Lager Dog Mike Original Premium Lager Dog John Stolichnaya Citrona

Explanation / Answer

Answer is as follows :

The SQL quesry for given scenario is as follows :

SELECT drinker FROM likes WHERE beer = "Hefeweizen" AND beer = "Killian's" ;

it will provide you no result.

if there is any query please ask in comments...

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.