Laptop vs. Mobile Viewership
Calculate the total viewership for laptops and mobile devices. Mobile is defined as the sum of tablet and phone viewership. Output laptop_views and mobile_views.
Tables: viewership
SQL practice / The New York Times
Free SQL interview practice
The New York Times SQL interview questions. All free.
1 SQL practice question in our The New York Times collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
1 Easy
Independent practice resource. Not affiliated with or endorsed by The New York Times.
Inside the The New York Times set
SQL topics you can practice.
These topics come from the questions in this set. Pick one to open the matching problems.
The bank
The New York Times SQL questions. Start typing SQL.
1 The New York Times problem, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
How it works
Solve in the browser. Checked instantly.
- 1Pick a problemPractice questions for data science and analytics interviews, each with its own tables, difficulty, and time target.
- 2Write and run SQLA full database engine loads in the tab. No setup, nothing to install — query the practice dataset immediately.
- 3Submit for a verdictPass and move to the next problem. Miss and you unlock the expected output and a reference solution.
Your dataset
viewership
user_id (INTEGER) · device_type (VARCHAR) · view_time (FLOAT)
1
The New York Times question
188
questions in the full bank
$0
free access
Solve one now. Build your solved history.
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice The New York Times SQL freeExplore SQL questions by company.
188 SQL practice questions. 23 companies. Free access to every problem.