Interview Query

Niantic Interview Questions

IQ Team
Written by IQ Team
Jay Feng
Reviewed by Jay Feng
Published March 27, 2026
Estimated reading time: 5 minutes

Back to company list


Table of contents

Niantic Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(14)
Product Sense & Metrics
(13)
Data Structures & Algorithms
(9)
Statistics
(8)
SQL
(7)

Niantic Interview Questions

Practice for the Niantic interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Hard

Given a table of subscriptions, write a query to get the retention rate of each monthly cohort for each plan_id for the three months after sign-up.

Order your output by start_month, plan_id, then num_month.

If an end_date is in the same month as start_date we say the subscription was not retained in the first month.

If the end_date occurs in the month after the month of start_date, the subscription was not retained in the second month. And so on for the third.

The end_date field is NULL if the user has not canceled.

Schema:

Input:

subscriptions table

Column Type
user_id INTEGER
start_date DATETIME
end_date DATETIME
plan_id VARCHAR

Output:

Column Type
start_month DATETIME
num_month INTEGER
plan_id VARCHAR
retained FLOAT

Example

Input:

subscriptions table

user_id start_date end_date plan_id
1 2020-01-10 00:00:00 2020-03-31 23:59:59 plan1
2 2020-01-10 00:00:00 2020-02-01 23:59:59 plan1
3 2020-01-10 00:00:00 2020-07-31 23:59:59 plan1

Output:

start_month num_month plan_id retained
2020-01-01 1 plan1 1.0
2020-01-01 2 plan1 0.67
2020-01-01 3 plan1 0.33

Explanation:

  • Cohort: All subscriptions starting in January 2020.
  • Month 1 retention: All 3 users were active in the first month → 3⁄3 = 1.0
  • Month 2 retention: Only users 1 and 3 were active in Feb → 2⁄3 ≈ 0.67
  • Month 3 retention: Only user 3 was active in Mar → 1⁄3 ≈ 0.33
View Question
Show Solution
SQL
Easy
SQL
Medium
SQL
Easy
Machine Learning
Medium
Statistics
Medium
SQL
Hard
Machine Learning
Medium
Python
Easy
Deep Learning
Hard
SQL
Medium
Statistics
Easy
Machine Learning
Hard

View all Niantic, Inc. questions

Challenge

Check your skills...
How prepared are you for working at Niantic, Inc.?

Niantic Salaries by Position

Product Manager*
$175K
Product Manager
Median: $175K
Mean (Average): $175K
Data points: 1
Software Engineer
$119K
$212K
Software Engineer
Median: $168K
Mean (Average): $167K
Data points: 33
Data Scientist*
$155K
Data Scientist
Median: $155K
Mean (Average): $155K
Data points: 4
Marketing Analyst*
$144K
Marketing Analyst
Median: $144K
Mean (Average): $144K
Data points: 2
Base salary
Median
Mean (Average)
* = Low confidence (less than 5 data points)

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Product Manager role pays the most with a $175,000 base salary while the Marketing Analyst role on average pays the least with a $144,000 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.
Position interview guides
Niantic, Inc. Data Scientist Interview Questions + Guide in 2025Niantic, Inc. Product Manager Interview Questions + Guide in 2025Niantic, Inc. Software Engineer Interview Questions + Guide in 2025

Discussion & Interview Experiences

There are no comments yet. Start the conversation by leaving a comment.

Jump to Discussion