Git存储库的SQL查询

--从提交中获取回购历史中每个提交的ID和作者电子邮件SELECT ID，Author_Email。

-。

--打印总提交分配百分比条形图(按作者姓名)，TOTAL_COMMITS(TOTAL)AS(SELECT COUNT(*)AS TOTAL FROM COMMITS)SELECT AUTER_NAME，ROUNT(*)*100.0/(SELECT TOTAL FROM TOTAL_COMMITS)，2)AS百分比，printf('；%.'；||(CAST(ROUND(COUNT(*)*100.0/(SELECT TOTAL FROM TOTAL_COMMITS))AS INT)+1)||'；c'；&#。)AS COMMITIONS FROM COMMITS BY AUTHER_NAME ORDER BY百分比DESC