Competency questions for the data model

Questions provided by @fera333

• How many works that are from authors who are not male or female are in the canon?

• How is the gender distrubition of authors in the canon from 1930 to 1945.

• Which is the most popular play by William shakespear?

• Which text appears on most canon lists?

• Which author has the most ratings on goodreads?

• Which are the 10 most popular works according to goodreads?

• Which 25 year publishing period is most representent in the canon?

• Which language is the most representet in the canon?

• Which is the most canonical author?

• Which is the canon with the highest female authors?

• Which canonlist has the higest popularity average?

• Which list has more popular works from 1925 to 2025?

• What is the most popular series of works in the canon?

• Which canon has the most male authors on average?

• Which author has the most indivdual works in the canonlists?

• Which work appears on most canonlists?

• List all authors that appear in list before 1990 but not after

• Which author has gained the most popularity in the canonlists from 1990 to 2025?

• How has the popularity of imperium by christian kracht changed over time?

• Which is the most popular work from chile?

• Which is the most representet continent?

• List all works which originate from africa.

• How has reader popularity of the works of umberto eco changed from 2010 to 2025?