Laptop vs Mobile Viewership — New York Times Asked SQL Question

Solving SQL Question asked by NYT

Suraj Mishra

·

Follow

2 min read

·

Nov 2, 2022

--

Share

Introduction

• In this article we will solve Laptop vs Mobile Viewership SQL question which is asked by New York Times as per DataLemur website.

If you don’t know DatLemur then please do visit , it’s one of the best website to practice SQL questions and improve your SQL skills.

Question

• We have been given viewership as input table , our goal is to find total_number views by device (mobile and laptop).
• Fyi, Mobile devices are combined of tablet and phone.

Solution

• we can basically filter input…