sql replace id with name from another table

Solutions on MaxInterview for sql replace id with name from another table by the best coders in the world