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.

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

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

Answer 6

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

Answer 7

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

Answer 8

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

Answer 9

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

Answer 10

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

Answer 11

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

Answer 12

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