在SQL中制定一个查询来检索数据库中的所有作者名字.作者表称为AUTHORS.有一个WORKS表,包含通过AUTHOR_FK连接的所有作者作品.作品本身存储为varchar,称为WORK.创建一个查询,以找到作者从他的书面作品中最多字的作者.
To retrieve the names of all authors in the database, you can use the following SQL query:

```
SELECT name FROM authors;
```

To find the author with the highest word count from his written works, you can use the following SQL query:

```
SELECT a.name, SUM(LENGTH(w.work) - LENGTH(REPLACE(w.work, ' ', '')) + 1) AS total_words
FROM authors a
INNER JOIN works w ON a.author_id = w.author_fk
GROUP BY a.name
ORDER BY total_words DESC
LIMIT 1;
```

This query joins the AUTHORS table with the WORKS table and calculates the total word count for each author. It then orders the results by the total word count in descending order and limits the output to the first row, which contains the author with the highest word count. The LENGTH function is used to count the number of characters in the WORK field, and the REPLACE function is used to remove spaces from the string. The +1 is used to count the last word in the string.