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.
11 Réponses
+ 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