write a query to display the due_date and payable amount that are all not paid in between '2017-09-10' to '2017-10-10'.

Question

Sql

Answer 1

Hello, please show us your attempts first. Then we can begin to help you. We usually don't do the homework for others. If so, you wouldn't learn anything.
Thank you.

Answer 2

SELECT due_date, payable_amount
FROM bill
WHERE due_date NOT BETWEEN '2017-09-10' AND '2017-10-10';