Your boss asks you to print the list of the first one hundred customers who have balances greater than $1000 or who are from NY. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Your boss asks you to print the list of the first one hundred customers who have balances greater than $1000 or who are from NY.

21st Dec 2016, 9:29 AM
AYYAPPARAJ T
11 Answers
+ 4
SELECT * FROM customers WHERE balance > 1000 OR city = 'NY' LIMIT 100
10th Jan 2018, 10:40 PM
Marat Petrosov
+ 1
SELECT * FROM customers WHERE balance > 1000 OR city = 'NY' LIMIT 100
9th Apr 2018, 4:18 PM
Mahnoor Shahzad
Mahnoor Shahzad - avatar
0
Have you written anything so far?
21st Dec 2016, 10:09 AM
James Durand
James Durand - avatar
0
SELECT name FROM customers WHERE balance > 1000 LIMIT 100 ORDERED BY DESC AND city IN('New York');
21st Dec 2016, 11:57 AM
Iván
Iván - avatar
0
SELECT TOP 100 name FROM Customers WHERE balance > 1000 AND city = 'NY'
22nd Dec 2016, 6:02 AM
lowshuen
0
where limit 100 Answer SELECT* FROM customers WHERE balance > 1000 LIMIT 100 ORDERED BY DESC AND city IN('New York');
3rd Jan 2017, 5:37 PM
Jan Sher
Jan Sher - avatar
0
aw olark anwer oist
25th Oct 2017, 12:43 PM
Roan Tom Javier Abendan
Roan Tom Javier Abendan - avatar
0
aww bitaw. id oam resna bai hahahah
25th Oct 2017, 12:47 PM
Galilouie R. Montecillo
Galilouie R. Montecillo - avatar
0
SELECT * FROM customers WHERE balance > 1000 OR city = 'NY' LIMIT 100
26th Feb 2018, 11:47 AM
Salman Aziz
Salman Aziz - avatar
0
All fine
14th May 2020, 10:12 AM
Hamoud ALrashdi
Hamoud ALrashdi - avatar
0
SELECT * FROM customers WHERE balance > 1000 OR city = 'NY' LIMIT 100
5th Jul 2020, 9:34 AM
Faith Mundi
Faith Mundi - avatar