he first query shows the ages of bears and birds from zoo1, the other shows the ages of lions and crocodiles from zoo2. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
- 1

he first query shows the ages of bears and birds from zoo1, the other shows the ages of lions and crocodiles from zoo2.

show correct answer

24th Oct 2017, 10:39 AM
vignesh rajasekaran
vignesh rajasekaran - avatar
3 Answers
+ 4
SELECT age From zoo1 WHERE animal IN('bear', 'bird') UNION SELECT age FROM zoo2 WHERE animal IN('lion', 'crocodile') if question looks like "You need the ages of all bears and lions. The first query shows the ages of bears and birds from zoo1, the other shows the ages of lions and crocodiles from zoo2."
19th Dec 2019, 6:06 PM
Zobo
Zobo - avatar
0
Try to explain better or copy/paste question/quiz here
18th Nov 2017, 7:56 AM
Daniel
Daniel - avatar
0
delete the table ''students'' from the database.
3rd Jun 2019, 9:13 AM
Suhail
Suhail - avatar