如题所述
SELECT 学号, 姓名, 性别, year(date())-year(出生日期) AS 年龄
FROM 学生
WHERE 性别="女" and year(date())-year(出生日期)<21
ORDER BY year(date())-year(出生日期)
FROM 学生
WHERE 性别="女" and year(date())-year(出生日期)<21
ORDER BY year(date())-year(出生日期)
温馨提示:答案为网友推荐,仅供参考