+ 1

Can sme1 give me the command to this query Get the first name, city, country, and invoiced amount of customers living either in Brazil or in Paris and with a total invoice greater than $38.

13th Sep 2016, 6:20 PM
Freeman Phiri
Freeman Phiri - avatar
12 ответов
+ 4
SELECT first_name, city, country, invoiced_amount FROM customers WHERE city='Brazil' OR city='Paris' AND invoiced_amount>38;
13th Sep 2016, 6:54 PM
Maria Bulus
+ 2
Tried that but its giving me values including the 38 of which its wrong
13th Sep 2016, 7:16 PM
Freeman Phiri
Freeman Phiri - avatar
+ 2
Select first name, city, country, invoices from customers where city IN('brazil', 'paris') and invoices >38
17th Sep 2016, 4:42 AM
MOHAMMED NIYAS.M
+ 1
try this will work sure
14th Sep 2016, 10:59 AM
Usha Garkoti
Usha Garkoti - avatar
+ 1
updated last one forgot to put dollar sign
14th Sep 2016, 11:01 AM
Usha Garkoti
Usha Garkoti - avatar
+ 1
Select first_name,city,country,invoice_amount From customers where city='Brazil' or 'Paris' and invoiced_amount>!$38
14th Sep 2016, 2:44 PM
kruthi
0
SELECT first_name, city, country, invoiced_amount FROM customers WHERE (city='Brazil' OR city='Paris') AND (invoiced_amount>38);
13th Sep 2016, 8:15 PM
Vernika Pushpanjay
0
Select firstname,city,country,invoiceamount from customers where city='Brazil' or 'Paris' and invoiveamount>!38;
14th Sep 2016, 10:58 AM
Usha Garkoti
Usha Garkoti - avatar
0
Select firstname,city,country,invoiceamount from customers where city='Brazil' or 'Paris' and invoiveamount>!$38;
14th Sep 2016, 11:01 AM
Usha Garkoti
Usha Garkoti - avatar
0
select first_name,city,country, invoiced_amount from customers where ( country='Brazil' OR 'paris' ) and invoice >=$38;
16th Sep 2016, 5:50 PM
Madhuri
0
Select first name, city, country, invoices from customer where country ='brazil' or 'Paris' and invoices > 38
17th Sep 2016, 4:35 AM
MOHAMMED NIYAS.M
- 1
select name , city, country, invoiced amount from table name where customer living = Brazil or Paris and invoice> $38
14th Sep 2016, 6:25 PM
B.Vigneshwar Prasad
B.Vigneshwar Prasad - avatar