Drag and drop from the options below to complete the statement, which selects ''name'' and minimum of the "cost'' from ''items'' | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

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

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

18th Jan 2020, 8:50 AM
Nur Aliman
Nur Aliman  - avatar
5 Answers
+ 2
You can use- MIN(cost) LIKE '%boxes of frogs' seller_id IN(68,6,18)
18th Jan 2020, 9:03 AM
Avinesh
Avinesh - avatar
+ 1
Please answer,
26th Jul 2020, 2:14 AM
Manju Kushwaha
Manju Kushwaha - avatar
0
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)
20th Nov 2020, 1:29 PM
Jason Chew
Jason Chew - avatar
- 2
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
9th May 2020, 5:07 PM
Faraoun Miloud
- 2
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 )
26th Jul 2020, 2:13 AM
Manju Kushwaha
Manju Kushwaha - avatar