text: SELECT DISTINCT CUSTOMER.gender,BILL.amount
  FROM CUSTOMER,CART,CARTDETAILS,BILL
  WHERE CUSTOMER.cid=CART.cid,CART.cartid=CARTDETAILS.cartid,CARTDETAILS.iid=BILL.iid,BILL.amount<"1000",BILL.amount>"500"