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.

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

try this will work sure

Answer 5

updated last one forgot to put dollar sign

Answer 6

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

Answer 7

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

Answer 8

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

Answer 9

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

Answer 10

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

Answer 11

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

Answer 12

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