我写了这个查询
系统显示enter image description here
如何解决这一问题？
The code should only show those data within the two date we enter.

ACCEPT sDate CHAR FORMAT 'A10' PROMPT ' Enter the start date:  '
ACCEPT ednDate CHAR FORMAT 'A10' PROMPT ' Enter the end date:  '

SELECT s.customerID, c.fname, m.memberID, salesID, co.countriesName, p.productName,s.totalAmount,s.totalAmount*discountAmount AS subtotal,salesdate
FROM sales s, customers c, member m, list l, discount d, product p,shop sh,countries co
WHERE c.customerID = m.customerID AND
    m.memberID = d.memberID AND
    d.discountID = s.discountID AND
    s.listID = l.listID AND
    l.productID = p.productID AND
    s.shopID = sh.shopID AND
    sh.countriesID = co.countriesID AND
    salesdate BETWEEN TO_DATE(sDate, 'DD/MM/YYYY') AND TO_DATE(ednDate, 'DD/MM/YYYY')
order by customerID,salesdate;