The Climate Corp Interview Questions

The Climate Corp Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(78)
Machine Learning
(50)
SQL
(28)
Probability
(27)
Statistics
(18)

The Climate Corp Interview Questions

Practice for the The Climate Corp 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
SQL
Easy
Loading pricing options

View all The Climate Corporation questions

Challenge

Check your skills...
How prepared are you for working at The Climate Corporation?

The Climate Corp Salaries by Position

ML Engineer*
$118K
$179K
ML Engineer
Median: $149K
Mean (Average): $149K
Data points: 2
$125K
$162K
Software Engineer
Median: $140K
Mean (Average): $142K
Data points: 6
$85K
$160K
Data Engineer
Median: $135K
Mean (Average): $126K
Data points: 15
$94K
$153K
Data Scientist
Median: $120K
Mean (Average): $123K
Data points: 16
$70K
$110K
Data Analyst
Median: $94K
Mean (Average): $91K
Data points: 6

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

From the graph we can see that on average the ML Engineer role pays the most with a $148,500 base salary while the Data Analyst role on average pays the least with a $91,183 base salary.

Discussion & Interview Experiences

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