Laptop and mobile views
The analytics team is comparing views across device types: laptop, tablet, and phone. Count the number of views from laptops and the number of views from mobile devices. Mobile devices include tablet and phone. Return two columns: laptop_views and mobile_views.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| laptop_views | mobile_views |
|---|---|
| 5 | 7 |
New York Times
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid