I want to write a query that returns one line, for each unique IP address, with the first instance of the lowest date as "MinDate" and the last instance of the date (most recent) as max date, with a count where it's "TRUE" ignoring the false count records.

Is googling group by, and assuming to use min() and max() for the date expressions the correct approach?