Ace american insurance company Interview Questions

Ace american insurance company Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(18)
SQL
(6)
Statistics
(6)
Probability
(5)
Product Sense & Metrics
(5)

Ace american insurance company Interview Questions

Practice for the Ace american insurance company interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Easy

Write a SQL query to select the 2nd highest salary in the engineering department.

Note: If more than one person shares the highest salary, the query should select the next highest salary.

Example:

Input:

employees table

Column Type
id INTEGER
first_name VARCHAR
last_name VARCHAR
salary INTEGER
department_id INTEGER

departments table

Column Type
id INTEGER
name VARCHAR

Output:

Column Type
salary INTEGER
SQL
Medium
Product Sense & Metrics
Medium
Loading pricing options

View all Ace american insurance company questions

Challenge

Check your skills...
How prepared are you for working at Ace american insurance company?

Ace american insurance company Salaries by Position

$87K
$116K
Data Engineer
Median: $105K
Mean (Average): $102K
Data points: 9
$78K
$119K
Data Scientist
Median: $98K
Mean (Average): $99K
Data points: 11
$89K
$104K
Business Analyst
Median: $89K
Mean (Average): $93K
Data points: 6
$79K
$94K
Data Analyst
Median: $87K
Mean (Average): $87K
Data points: 4
Product Analyst*
$85K
Product Analyst
Median: $85K
Mean (Average): $85K
Data points: 1
AI Research Scientist*
$81K
$88K
AI Research Scientist
Median: $84K
Mean (Average): $84K
Data points: 2

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

From the graph we can see that on average the Data Engineer role pays the most with a $101,972 base salary while the AI Research Scientist role on average pays the least with a $84,209 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