Interview Query

Shutterfly 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

Shutterfly Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(81)
Machine Learning
(64)
SQL
(64)
Probability
(38)
Product Sense & Metrics
(29)

Shutterfly Interview Questions

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

QuestionTopicDifficulty
SQL
Easy

We’re given two tables, a users table with demographic information and the neighborhood they live in and a neighborhoods table.

Write a query that returns all neighborhoods that have 0 users. 

Example:

Input:

users table

Columns Type
id INTEGER
name VARCHAR
neighborhood_id INTEGER
created_at DATETIME

neighborhoods table

Columns Type
id INTEGER
name VARCHAR
city_id INTEGER

Output:

Columns Type
name VARCHAR
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 Shutterfly, Inc. questions

Challenge

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

Shutterfly Salaries by Position

Product Manager*
$192K
Product Manager
Median: $192K
Mean (Average): $192K
Data points: 1
Business Intelligence*
$135K
$140K
Business Intelligence
Median: $138K
Mean (Average): $138K
Data points: 2
Data Scientist
$116K
$149K
Data Scientist
Median: $139K
Mean (Average): $135K
Data points: 6
Data Engineer
$102K
$160K
Data Engineer
Median: $121K
Mean (Average): $127K
Data points: 22
Software Engineer
$89K
$149K
Software Engineer
Median: $124K
Mean (Average): $120K
Data points: 18
Data Analyst*
$104K
Data Analyst
Median: $104K
Mean (Average): $104K
Data points: 1
Business Analyst*
$85K
$111K
Business Analyst
Median: $85K
Mean (Average): $93K
Data points: 4
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 $192,000 base salary while the Business Analyst role on average pays the least with a $92,500 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.
Position interview guides
Shutterfly, Inc. Data Analyst Interview Questions + Guide in 2025Shutterfly, Inc. Data Engineer Interview Questions + Guide in 2025Shutterfly, Inc. Data Scientist Interview Questions + Guide in 2025Shutterfly, Inc. Marketing Analyst Interview GuideShutterfly, 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