Sqliteviz allows building pivot tables and visualizing them. To build a pivot run a query to get data. Then open visualisation panel by clicking in any of the two side toolbars and choose a pivot mode ...
Return the lastest inDate for each breed, but it is not pretty If you want to see the breed that was the most recent inDate for each pet type, then this will not return the results you want. MAX on ...