在xml文件中怎么写SELECT id,name,sex,YEAR(NOW())-birth as age,department,address FROM student where YEAR(NOW())-birth >=18 and YEAR(NOW())-birth <=35;

你可以这样写：

在xml文件中，可以使用以下语句来查询符合条件的学生信息：

<query>
SELECT id,name,sex,YEAR(NOW())-birth as age,department,address
FROM student
WHERE YEAR(NOW())-birth >=18 AND YEAR(NOW())-birth <=35;
</query>