How to replicate the 'Audience | Behavior | New vs Returning' report

A query to generate the Google Analytics New vs Returning report in BigQuery. In this report you'll find data about acquisition, behaviour and conversion of your users, segmented by user type.