Compound Expression

Question

Please help. I have a table called Customers. I have to get the first name and invoice total of customers whose invoice is less than or equal to 40 WITHOUT using the less or equal operator. Something like:
SELECT FirstName, InvoiceTotal FROM Customers WHERE InvoiceTotal........

Answer 1

Hi, the only way u could do that is by querying "...InvoiceTotal <= 40". I assure u there's no any bypass to use less or equal operators at least in that case!😊

Answer 2

finally got it! 3 days later!....."WHERE Invoice Total BETWEEN 0 AND 40" Thanks!