SELECT work_id, work_name
FROM work_list
WHERE work_name IN (
    SELECT work_name
    FROM work_list
    GROUP BY work_name
    HAVING COUNT(work_name) > 1
) order by work_name




SELECT bus_id, reg_no, bus_status
FROM bus_info
WHERE reg_no IN (
    SELECT reg_no
    FROM bus_info
    GROUP BY reg_no
    HAVING COUNT(reg_no) > 1
) order by reg_no