S&P Global Interview Questions

S&P Global Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(69)
SQL
(38)
Machine Learning
(31)
Probability
(19)
Statistics
(13)

S&P Global Interview Questions

Practice for the S&P Global 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
Easy
SQL
Medium
Loading pricing options

View all S&P Global questions

Challenge

Check your skills...
How prepared are you for working at S&P Global?

S&P Global Salaries by Position

$96K
$186K
Data Engineer
Median: $121K
Mean (Average): $133K
Data points: 10
$110K
$167K
Data Scientist
Median: $124K
Mean (Average): $132K
Data points: 39
$112K
$140K
ML Engineer
Median: $129K
Mean (Average): $127K
Data points: 4
Product Manager*
$125K
Product Manager
Median: $125K
Mean (Average): $125K
Data points: 1
Business Intelligence*
$120K
Business Intelligence
Median: $120K
Mean (Average): $120K
Data points: 1
$65K
$137K
Software Engineer
Median: $102K
Mean (Average): $102K
Data points: 36
$70K
$125K
Business Analyst
Median: $93K
Mean (Average): $95K
Data points: 10
$75K
$95K
Data Analyst
Median: $90K
Mean (Average): $86K
Data points: 3

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 $132,998 base salary while the Data Analyst role on average pays the least with a $86,310 base salary.

Discussion & Interview Experiences

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