SELECT date, 
       SUM(totals.visits) AS sessions
FROM [google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910]
WHERE totals.transactions > 0
GROUP BY date

-- http://www.lunametrics.com/blog/2016/06/23/google-analytics-bigquery-export-schema/