SELECT t.card_number '身份证号',SUBSTR(t.card_number,,) AS "省份", SUBSTR(t.card_number,,) "出生年月", SUBSTR(t.card_number,,) "性别" , CASE (SUBSTR(t.card_number,,)%) WHEN THEN '男' WHEN THEN '女' END AS '性别' FROM user t ;