sql实现业务取每个班级中成绩最好的前三名，按照时间排序

 SELECT
            a.*
        FROM
            (
                SELECT
                    h.hub_code,
                    p.port_code,
                    pcp.base_arrival_time,
                    vs.service_code,
                    pcp.voyage_no,
                    v.vessel_code,
                    p.latitude,
                    p.longitude
                    -- 	SELECT *
                FROM
                    port_call_prediction pcp,
                    service_sequence ss,
                    PORT p,
                    hub h,
                    voyage_service vs,
                    vessel v
                WHERE