SELECT pc.MACB, nv.MANV, nv.TEN
FROM NHANVIEN nv JOIN PHANCONG pc ON nv.MANV = pc.MANV
		 JOIN LICHBAY lb ON lb.MACB = pc.MACB
		 JOIN CHUYENBAY cb ON cb.MACB = lb.MACB
WHERE cb.SBDI = 'MIA' AND cb.GIODI = '20:30' AND lb.NGAYDI = '10/31/2000'