Write a query to count the number of Users who only used mobile apps; Users who only used web apps, Users used both mobile and web Return 3 columns: num_web_only_users, num_mobile_only_users, num_web_and_mobile_users.

Prev Discuss

Question 107

Customer count by platform

Unsolved Medium google Lecture

Premium Access

Unlock this Google interview question.

230+ interview questions
Official solutions
SQL, Python, and R tracks

***** * ***** ** ***** *** ****** **
1. ***** *** **** **** ****** ****;
2. ***** *** **** **** *** ****,
3. ***** **** **** ****** *** ***
****** 3 *******: ***_***_****_*****, ***_******_****_*****, ***_***_***_******_*****.

Table 1: session_mobile

***** **** * **** ***** *** ****** *** (***, *******), * *** ******* ******, ** **** **** *** **** ****** *** ***.

  ***_****       | ***_****
-----------------+---------------------
****             | ****    
****_**          | ******
*******_**       | ******
*****            | *******(20)

Table 2: session_web

***** **** * **** ****** *** *******, * *** ******* ******, ** **** **** *** **** ****** *** ****.

  ***_****       | ***_****
-----------------+---------------------
****             | ****    
****_**          | ******
*******_**       | ******
*****            | *******(20)

Sample results

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine

Interview timer

Recommended interview pacing

Easy: 5 min for direct warm-up style questions.

Medium: 10 min for multi-step interview queries.

Hard: 15 min for layered questions with tighter time pressure.

A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.

10:00

Timer

Your results

Run your query to preview results here.

More Google Questions

Browse Company Set

Question	Level	FTPR
#101. Average number of visits per user	Easy	14%
#102. Histogram by visit session duration	Hard	17%
#103. Median and average session duration by day of the week	Medium	20%
#104. MAU: Monthly active users	Easy	20%
#105. Number of days gap between last two actions	Hard	8%
#106. Mobile vs. web	Medium	10%
#147. 2 days streak customers	Hard	13%
#148. Most popular video category	Medium	13%
#149. fans by video category	Easy	36%
#150. Countries with above average customers	Easy	15%
#186. Average comments per question	Easy	10%
#187. Comment distribution at Google Forum	Easy	17%
#188. Top 1 popular question by department	Hard	14%