select("sales.id as sid, MAX(date), MAX(customer_name), MAX(reference_no),
        MAX(total), MIN(total), MAX(total_tax)")
from('sales');