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)

Options : IN LIKE NOT BETWEEN AVG MIN

Answer 1

Well, the instruction was rather incomplete, there's a WHERE clause included, anyway:

MIN
LIKE
IN

That's the order of options to drop in the blanks. I suggest you learn the SELECT statement so you can understand what the query means.

Hth, cmiiw

Answer 2

You're welcome, glad to help :)

Answer 3

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

Answer 4

Thank you so much for your help.

Answer 5

Thank you so much for your help.

Answer 6

Drag and drop from the options below to print only the items in the set "a" that are not in the set "b".

Answer 7

SELECT name, MIN(cost)
FROM items WHERE name
BETWEEN '%boxes of frogs' AND
seller id LIKE (68, 6, 18)

Answer 8

Drag y drop to select the users that have 5000. Order the resulting list by the name column in ascending order?

Answer 9

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

Answer 10

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

Answer 11

Select where desc

Answer 12

Drag and drop from the options below to print only the items in the set "a" that are not in the set "b".

Answer 13

Drag and drop from the options below to print only the items in the set "a" that are not in the set "b".

Answer 14

Drag and drop from the options below to complete the command to list all of the databases.?
help me plizz [e-mail]