The birth of a child is a major life event for a person so I thought it would be worth adding to the stream of events query for a person. This query is designed to be pasted into the AllFacts4Person5.sql file – it follows the same columnar format – or it can be run on its own. For some unknown reason, it was unnecessary to mess with INDEXED BY and NOT INDEXED clauses to get fast results so this query should run on all flavours of SQLite3.
File updated with labels for Parent name columns and tested on RM7 and #rm8. TH 2021-03-03
Screen shot from SQLite Developer – note the filter drop-down list box on the Count column.