HiveSQL
HiveSQL copied to clipboard
canel OVER ()
SELECT name, COUNT(*) OVER () FROM business WHERE SUBSTRING(orderdate, 1, 7) = '2017-04' GROUP BY name;
canel OVER ()