query to retrieve sale