Bigquery + Colab

 This intuitive feature is useful to get results and perform ML-related analysis.

	select
	100 * countif(ColA is null) / count(1) as ColA,
	100 * countif(ColB is null) / count(1) as ColB,
	from `TableA`
	select bins, count(1) as 'Number of users' from (
	select
	case when logcount >= 0 and logcount <= 10 then ' 0 - 10'
	when logcount > 10 and logcount <= 50 then ' 10+ - 50'
	when logcount > 50 and logcount <= 100 then ' 50+ - 100'
	else 'over 100'
	end bins
	from TableA

view raw queries.sql hosted with ❤ by GitHub

Keep Exploring!!!