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) Options : IN LIKE NOT BETWEEN AVG MIN

25th Sep 2017, 2:18 PM
Tawfiquzzaman Opu
Tawfiquzzaman Opu - avatar
14 Respuestas
+ 14
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
25th Sep 2017, 4:49 PM
Ipang
+ 3
You're welcome, glad to help :)
28th Sep 2017, 3:07 PM
Ipang
+ 1
SELECT name, MIN (cost) FROM items WHERE name LIKE '%boxes of frogs' AND seller_id IN (68, 6, 18)
7th Apr 2018, 5:13 PM
Mahnoor Shahzad
Mahnoor Shahzad - avatar
0
Thank you so much for your help.
28th Sep 2017, 3:06 PM
Tawfiquzzaman Opu
Tawfiquzzaman Opu - avatar
0
Thank you so much for your help.
22nd Sep 2018, 5:11 AM
abdou raouf Nchouwat
abdou raouf Nchouwat - avatar
0
Drag and drop from the options below to print only the items in the set "a" that are not in the set "b".
22nd Sep 2019, 12:49 PM
VERY SUHANDI
VERY SUHANDI - avatar
0
SELECT name, MIN(cost) FROM items WHERE name BETWEEN '%boxes of frogs' AND seller id LIKE (68, 6, 18)
25th Feb 2023, 10:18 AM
Isaac Friday
Isaac Friday - avatar
0
Drag y drop to select the users that have 5000. Order the resulting list by the name column in ascending order?
7th Jun 2023, 12:21 AM
Jose Taveras Estevez
Jose Taveras Estevez - avatar
- 1
SELECT name, MIN (cost) FROM items WHERE name LIKE '%boxes of frogs' AND seller_id IN (68, 6, 18)
31st Jul 2019, 10:05 AM
SHARMA N
SHARMA N - avatar
- 1
SELECT name, MIN (cost) FROM items WHERE name LIKE '%boxes of frogs' AND seller_id IN (68, 6, 18)
24th Nov 2019, 9:29 AM
IBRAHIM AHMAD
IBRAHIM AHMAD - avatar
- 1
Select where desc
20th Mar 2020, 3:02 PM
Garvita Sharma
Garvita Sharma - avatar
- 3
Drag and drop from the options below to print only the items in the set "a" that are not in the set "b".
22nd Apr 2019, 12:49 PM
putri esmeralda
putri esmeralda - avatar
- 4
Drag and drop from the options below to print only the items in the set "a" that are not in the set "b".
29th May 2020, 3:11 PM
shweta shukla
shweta shukla - avatar
- 4
Drag and drop from the options below to complete the command to list all of the databases.? help me plizz javlonbekshoyimqulov@gmail.com
2nd Jun 2020, 1:46 AM
javlonbek shoyimqulov
javlonbek shoyimqulov - avatar