+ 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.
12 ответов
+ 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