def _select(self):
        select_str = """
             SELECT row_number() OVER() as id,
             a.type_id AS type_id,
             a.vehicle_id AS vehicle_id,
             a.driver_id AS driver_id,
             a.co_driver_id AS co_driver_id,
             a.date_start AS date_start,
             a.date_end AS date_end,
             a.real_date_depart AS real_date_depart,
             a.real_date_arrive AS real_date_arrive,
             a.start_location_id AS start_location_id,
             a.end_location_id AS end_location_id,
             a.state AS state,
             SUM(a.end_odometer - a.start_odometer) AS odometer,
             SUM(a.distance) AS distance
        """
        return select_str