Add Query - How does an authors commits change over time with respect to code/comments percentage?

[Blargian]

Describe the query

How does an authors commits change over time with respect to code/comments percentage?

This query is linked in the documentation but the link is broken. I noticed that this query does not yet exist so we should add it and update the broken link.

See: query on this page

SELECT
    author,
    countIf(line_type = 'Code') AS code_lines,
    countIf((line_type = 'Comment') OR (line_type = 'Punct')) AS comments,
    code_lines / (comments + code_lines) AS ratio_code,
    toStartOfWeek(time) AS week
FROM git.line_changes
GROUP BY
    time,
    author
ORDER BY
    author ASC,
    time ASC
LIMIT 10

[gingerwizard]

@lio-p