The Jackson Laboratory Interview Questions

The Jackson Laboratory Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(23)
Data Structures & Algorithms
(13)
SQL
(10)
Behavioral
(8)
Product Sense & Metrics
(6)

The Jackson Laboratory Interview Questions

Practice for the The Jackson Laboratory interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

Write a query to show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).

Example:

Input:

transactions table

Column Type
id INTEGER
user_id INTEGER
created_at DATETIME
product_id INTEGER
quantity INTEGER

products table

Column Type
id INTEGER
name VARCHAR
price FLOAT

users table

Column Type
id INTEGER
name VARCHAR
sex VARCHAR

Output:

Column Type
month INTEGER
num_customers INTEGER
num_orders INTEGER
order_amt INTEGER
SQL
Hard
A/B Testing
Medium
Loading pricing options

View all The Jackson Laboratory questions

Challenge

Check your skills...
How prepared are you for working at The Jackson Laboratory?

The Jackson Laboratory Salaries by Position

Software Engineer*
$91K
Software Engineer
Median: $91K
Mean (Average): $91K
Data points: 2
Business Analyst*
$85K
Business Analyst
Median: $85K
Mean (Average): $85K
Data points: 1
$57K
$95K
AI Research Scientist
Median: $74K
Mean (Average): $74K
Data points: 42
Data Analyst*
$68K
Data Analyst
Median: $68K
Mean (Average): $68K
Data points: 1

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

From the graph we can see that on average the Software Engineer role pays the most with a $90,875 base salary while the Data Analyst role on average pays the least with a $68,000 base salary.

Discussion & Interview Experiences

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

Discussion & Interview Experiences

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

Jump to Discussion