what is the proper arrangement

Question

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.

SELECT age FROM zoo1
WHERE animal IN ('lion', 'crocodile')
UNION
WHERE animal IN ('bear', 'bird')
SELECT age FROM zoo2

Answer 1

SELECT age FROM zoo1
WHERE animal IN ('bear', 'bird')
UNION
SELECT age FROM zoo2
WHERE animal IN ('lion', 'crocodile')

Answer 2

SELECT age FROM zoo1
WHERE animal IN ('bear', 'bird')
UNION
SELECT age FROM zoo2
WHERE animal IN ('lion', 'crocodile')

Answer 3

what is the proper arrangement

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.

SELECT age FROM zoo1
WHERE animal IN ('lion', 'crocodile')
UNION
WHERE animal IN ('bear', 'bird')
SELECT age FROM zoo2

Answer 4

SELECT age FROM zoo1
WHERE animal IN ('bear', 'bird')
UNION
SELECT age FROM zoo2
WHERE animal IN ('lion', 'crocodile')

Answer 5

please give me correct quastion

Answer 6

+2

SELECT age FROM zoo1
WHERE animal IN ('bear', 'bird')
UNION
SELECT age FROM zoo2
WHERE animal IN ('lion', 'crocodile')

Answer 7

Select age From zoo1
Where animal In('bear','bird')
Union
Select age From zoo2
Where animal In('lion','crocodile')

Answer 8

SELECT age FROM zoo1
WHERE animal IN ('bear', 'bird')
UNION
SELECT age FROM zoo2
WHERE animal IN ('lion', 'crocodile')

Answer 9

SELECT age FROM zoo1
WHERE animal IN ('bear', 'bird')
UNION
SELECT age FROM zoo2
WHERE animal IN ('lion', 'crocodile')

Answer 10

SELECT age FROM zoo1
WHERE animal IN ('bear', 'bird')
UNION
SELECT age FROM zoo2
WHERE animal IN ('lion', 'crocodile')