DataLemur: Laptop vs. Mobile Viewership

Rodrigo Vallejos included in DataLemur

2023-05-16 2023-05-16 29 words One minute

1
2
3
4
5
6
7


SELECT 
  (SELECT COUNT(*) 
   FROM viewership 
   WHERE device_type = 'laptop') AS laptop_views,
  (SELECT COUNT(*) 
   FROM viewership 
   WHERE device_type IN ('tablet', 'phone')) AS mobile_views