You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT
StartDate,
MobilePhoneModel AS Phone,
count() *10AS PageViews
FROMdatasets.visits_v1
SAMPLE 0.1-- In this example, the query is executed on a-- sample from 0.1 (10%) of data. Values of-- aggregate functions are not corrected-- automatically, so to get an approximate-- result, the value 'count()' is manually-- multiplied by 10.WHERE NOT empty(Phone)
AND StartDate BETWEEN '2014-03-17'AND'2014-03-30'GROUP BY StartDate, Phone
ORDER BY PageViews DESC;