Interview Query

Johns Hopkins University Applied Physics Laboratory Interview Questions

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

Back to company list


Table of contents

Johns Hopkins University Applied Physics Laboratory Interview Guides

Click or hover over a slice to explore questions for that topic.
A/B Testing
(12)
Data Structures & Algorithms
(11)
Machine Learning
(11)
Behavioral
(6)
SQL
(5)

Johns Hopkins University Applied Physics Laboratory Interview Questions

Practice for the Johns Hopkins University Applied Physics Laboratory interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Hard

The schema below is for a retail online shopping company consisting of two tables, attribution and user_sessions.

  • The attribution table logs a session visit for each row.

  • If conversion is true, then the user converted to buying on that session.

  • The channel column represents which advertising platform the user was attributed to for that specific session.

  • Lastly the user_sessions table maps many to one session visits back to one user.

First touch attribution is defined as the channel with which the converted user was associated when they first discovered the website.

Calculate the first touch attribution for each user_id that converted. 

Example:

Input:

attribution table

Column Type
session_id INTEGER
channel VARCHAR
conversion BOOLEAN

user_sessions table

column type
session_id INTEGER
created_at DATETIME
user_id INTEGER

Example output:

user_id channel
123 facebook
145 google
153 facebook
172 organic
173 email
View Question
Show Solution
Data Structures & Algorithms
Easy
Data Structures & Algorithms
Easy
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 The Johns Hopkins University Applied Physics Laboratory questions

Challenge

Check your skills...
How prepared are you for working at The Johns Hopkins University Applied Physics Laboratory?

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.
Position interview guides
The Johns Hopkins University Applied Physics Laboratory Business Analyst Interview Questions + Guide in 2025The Johns Hopkins University Applied Physics Laboratory Data Analyst Interview Questions + Guide in 2025The Johns Hopkins University Applied Physics Laboratory Data Scientist Interview Questions + Guide in 2025The Johns Hopkins University Applied Physics Laboratory 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