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 ;
05-12 19:54