SELECT
CONCAT(
LEFT(student_id_card, 6),
‘********’,
RIGHT(student_id_card, 4)
) AS student_id_card
FROM difficulty_job;