¡Nuevo curso! ¡Todo programador debería aprender IA Generativa!
Prueba una lección gratuita0
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.
11 Respuestas
+ 4
SELECT * FROM customers
WHERE balance > 1000
OR city = 'NY'
LIMIT 100
+ 1
SELECT * FROM customers
WHERE balance > 1000
OR city = 'NY'
LIMIT 100
0
Have you written anything so far?
0
SELECT name FROM customers
WHERE balance > 1000
LIMIT 100
ORDERED BY DESC
AND city IN('New York');
0
SELECT TOP 100 name
FROM Customers
WHERE balance > 1000
AND city = 'NY'
0
where limit 100
Answer
SELECT* FROM customers
WHERE balance > 1000
LIMIT 100
ORDERED BY DESC
AND city IN('New York');
0
aw olark anwer oist
0
aww bitaw. id oam resna bai hahahah
0
SELECT * FROM customers
WHERE balance > 1000
OR city = 'NY'
LIMIT 100
0
All fine
0
SELECT * FROM customers
WHERE balance > 1000
OR city = 'NY'
LIMIT 100