SQL ftw?

I have an SQL table called media that has a string feild called 'creator'.

I have a new SQL table called author that has a stirng feild called 'author_name'

I added a column to 'media' called author_id.

How do I select distinct authors from media and put each of them into author_name, and then link the author_id to the author table, all in pure SQL?

DROP TABLE media, authors;