new | SoloLearn: Learn to code for FREE!

-1

new

Drag and drop from the options below to select name, cost, and bids from the ''items'' table. Select only those items whose bids are greater than 123. name, , bids items bids>123; ON cost name ASC WHERE FROM SELECT

sql

12/18/2017 8:42:49 AM

Bura Sukumar

9 Answers

New Answer

+3

UPDATE zoo SET food_balance=23 WHERE age > (SELECT AVG(age) FROM zoo); to kawther Rabia AlHattali Drag and drop from the options below to update the food_balance to 23 for animals whose age is greater than the average age of the animals.

+1

I can help you with that, but I would rather suggest you to go back, and review the tutorial, it's rather basic, and I'm sure you can do this if you just give the tutorial a second view. Go give it a try!

+1

select from where i did correct answer on this question but here i displayed 3 correct answers only 4 out of so.. you can try for another answer.

0

select cost from where

0

SELECT name, cost , bids FROM items WHERE bids>123;

0

avg form

0

Drag and drop from the options below to update the food_balance to 23 for animals whose age is greater than the average age of the animals. UPDATE zoo SET food_balance=23 WHERE age > (SELECT (age) FROM );

0

Drag and drop from the options below to select all items from the ''items'' table for which cost is greater than 463. Order the result by cost in descending order. SELECT * FROM items WHERE cost > 463 ORDER BY cost DESC

0

LyricsBell.com is your online source of Hindi & Punjabi song lyrics from Bollywood movies and albums. We also provide audio and video of songs. https://www.lyricsbell.com/