Need help to solve this question in SQL? Get the first name, city, country, and invoiced amount of customers living either in country Brazil or in city Paris and with a total invoice greater than $38. | Sololearn: Learn to code for FREE!

+1

Need help to solve this question in SQL? Get the first name, city, country, and invoiced amount of customers living either in country Brazil or in city Paris and with a total invoice greater than $38.

7/14/2016 1:43:29 AM

Rosekamal

12 Answers

New Answer

+5

SELECT column_list FROM customers WHERE amount >= 38 AND (city = 'Paris' OR country = 'Brazil');

+2

Select fname,city,country,amount from table1 where country='brazil' or city ='paris' and amount›38

0

Select first name, city, country, invoiced amount from customers where country = 'Brazil' or city ='paris' and Invoiced amount > 38

0

that worked! I was making syntax error country= . still getting to be comfortable with and or. thanks folks!

0

@Rosekamal Don't forget to use parenthesis when nesting or you may end up with a results table that could cause you some headaches.

0

select first name,city,country,invoiced amount from customers where country = 'Brazil' or 'city Paris' AND total invoice > $38

0

@K Crage - yea, it took me a while to get used to ordering AND OR with Parenthesis. that's a wise suggestion!

0

select firstname,city,country,invoice from customers where(country='Brazil' or city='Paris') and MAX(invoice)>38;

0

how many tables are their? do all these columns exists in same table?

0

select firstname,city,country,invoiced_amt from customers where country='Brazil' or city='Paris' and invoiced _amt>38

0

SELECT fname, city, country, invoice FROM customerTable WHERE (city = 'Paris' OR country = 'Brazil') AND invoice >= 39;

-2

SELECT first name, city, country FROM column list WHERE (country = 'Brazil' or city ='Paris' AND invoiceAmount > $38);