Places+-+Count+People+and+Events+for+a+Group

This page presents a family of scripts that: An [|inquiry on Facebook] stimulated the development of these scripts.
 * 1) Creates a SQLite View of Standardized Place names in reverse order
 * 2) Lists Places used by the events of a Group of people and the quantity per Place of:
 * People
 * Events

This first script must be executed before the subsequent ones as it creates a set of SQLite Views used by them. The names of its Views are: xPlaceCommaView, xPlacePartsView, xPlaceReverseView in the order created, each building on its predecessor.

The following scripts are independent of each other but depend on the Views created by PlaceReverse.sql: Creates the View xPlacePersonView and then runs a SELECT query to produce the desired list. Creates the View xPlaceEventsView and then runs a SELECT query to produce the desired list. In both of the above scripts, there is the requirement to edit the GroupID number as instructed in the Comment. You could create a Group including Everyone in the database or any subset.