①通过文档id查询出文章标题文章内容文章发布日期发布时间。 5分②通过文档id查询出文章标题文章所在目录的名称文章发布日期3分③假设文章中存在图片通过文档id查询出文章标题文章内容文章日期图片访问路径。8分④ 通过人员id查询人员工号姓名姓名以及所在部门的名称。4分

① SELECT title, content, publish_date, publish_time FROM documents WHERE id = [文档id];

② SELECT d.title, c.name, d.publish_date FROM documents d INNER JOIN categories c ON d.category_id = c.id WHERE d.id = [文档id];

③ SELECT d.title, d.content, d.publish_date, p.path FROM documents d INNER JOIN pictures p ON d.id = p.document_id WHERE d.id = [文档id];

④ SELECT e.employee_number, e.name, d.name FROM employees e INNER JOIN departments d ON e.department_id = d.id WHERE e.id = [人员id];