Drag and drop from the options below to complete the statement, which selects ''name'' and minimum of the "cost'' from ''items''

Question

SELECT name, (cost)
FROM items WHERE name
'%boxes of frogs' AND
seller_id (68, 6, 18)
AVG IN LIKE NOT MIN BETWEEN

Answer 1

You can use-

MIN(cost)
LIKE '%boxes of frogs'
seller_id IN(68,6,18)

Answer 2

Please answer,

Answer 3

Drag and drop from the options below to select all items from the ''items'' table for which the cost is greater than the average of costs. Use a subquery to calculate the average cost.

SELECT * FROM items
WHERE cost >
(SELECT AVG(cost)
FROM items)

Answer 4

Drag and drop from the options below to select all items from the ''items'' table for which the cost is greater than the average of costs. Use a subquery to calculate the average cost.

SELECT * FROM items
cost >
(SELECT (cost)
FROM )
items AVG SUM WHERE IN COST

Answer 5

Drag and drop from the options below to select all items from the ''items'' table for which the cost is greater than the average of costs. Use a subquery to calculate the average cost.

SELECT * FROM items
cost >
(SELECT (cost)
FROM )