- 4

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

12th Mar 2017, 12:11 PM
abo El good
6 ответов
+ 2
Update animals set food_balance =23 where age>(Select avg(age) from animals);
12th Mar 2017, 1:06 PM
Meharban Singh
Meharban Singh - avatar
+ 2
UPDATE zoo SET food_balance=23 WHERE age > (SELECT AVG (age) FROM zoo );
10th Apr 2018, 10:40 AM
Mahnoor Shahzad
Mahnoor Shahzad - avatar
+ 1
SELECT*FROM zoo WHERE age SELECT AVG (age) From zoo
11th Sep 2020, 7:58 PM
OjeifoIduma
0
UPDATE zoo SET food_balance=23 WHERE age > (SELECT AVG(age) FROM zoo );
8th Oct 2020, 2:31 PM
Nirmal Hemram
Nirmal Hemram - avatar
- 1
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
6th Apr 2020, 9:20 AM
Vishal
Vishal  - avatar
- 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
18th Oct 2018, 10:36 AM
Airen Ranque
Airen Ranque - avatar