Update the food_balance to 23 for animals whose age is greater than the average age of the animals. UPDATE zoo SET food_balance

Answer 1

Update animals set food_balance =23 where age>(Select avg(age) from animals);

Answer 2

UPDATE zoo
SET food_balance=23
WHERE age >
(SELECT AVG (age)
FROM zoo );

Answer 3

SELECT*FROM zoo
WHERE age
SELECT AVG (age)
From zoo

Answer 4

UPDATE zoo
SET food_balance=23
WHERE age >
(SELECT AVG(age)
FROM zoo );

Answer 5

ou need your customer's names, along with the names of the cities in which they live. The names of the cities are stored in a separate table called "cities".

RIGHT
SELECT customers.name, cities.name
FROM customers
ON cities.id=customers.city_id;
OUTER JOIN cities

Unlock

Answer 6

You need your customer's names, along with the names of the cities in which they live. The names of the cities are stored in a separate table called "cities".

SELECT customers.name, cities.name
ON cities.id=customers.city_id;
FROM customers
OUTER JOIN cities
RIGHT