I published my talk "JSON By Example" in PostgreSQL Developer Raum at the FOSDEM on 31st of January 2016 including the SQL statements on GitHub https://github.com/sjstoelting/talks/tree/master/json-by-example.
The video has been published and is available at https://video.fosdem.org/2016/h1309/json-by-example.mp4
Published on 2016-02-01