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. | Sololearn: Learn to code for FREE!

+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.

9/13/2016 6:20:43 PM

Freeman Phiri

12 Answers

New Answer

+4

SELECT first_name, city, country, invoiced_amount FROM customers WHERE city='Brazil' OR city='Paris' AND invoiced_amount>38;

+2

Tried that but its giving me values including the 38 of which its wrong

+2

Select first name, city, country, invoices from customers where city IN('brazil', 'paris') and invoices >38

+1

try this will work sure

+1

updated last one forgot to put dollar sign

+1

Select first_name,city,country,invoice_amount From customers where city='Brazil' or 'Paris' and invoiced_amount>!$38

0

SELECT first_name, city, country, invoiced_amount FROM customers WHERE (city='Brazil' OR city='Paris') AND (invoiced_amount>38);

0

Select firstname,city,country,invoiceamount from customers where city='Brazil' or 'Paris' and invoiveamount>!38;

0

Select firstname,city,country,invoiceamount from customers where city='Brazil' or 'Paris' and invoiveamount>!$38;

0

select first_name,city,country, invoiced_amount from customers where ( country='Brazil' OR 'paris' ) and invoice >=$38;

0

Select first name, city, country, invoices from customer where country ='brazil' or 'Paris' and invoices > 38

-1

select name , city, country, invoiced amount from table name where customer living = Brazil or Paris and invoice> $38