new

Question

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

Answer 1

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

Answer 2

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.

Answer 3

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!

Answer 4

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.

Answer 5

select
cost
from
where

Answer 6

avg
form

Answer 7

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 );

Answer 8

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

Answer 9

Write a query to output a new table with each animal's name, type and country fields, sorted by

Answer 10

SELECT name, Cost, bids
FROM items
WHERE bids>123
maybe alright...