Agama solutions Interview Questions

Agama solutions Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(41)
Data Structures & Algorithms
(33)
SQL
(20)
Probability
(17)
Statistics
(12)

Agama solutions Interview Questions

Practice for the Agama solutions 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
Medium
Loading pricing options

View all Agama solutions questions

Challenge

Check your skills...
How prepared are you for working at Agama solutions?

Agama solutions Salaries by Position

Data Engineer*
$146K
Data Engineer
Median: $146K
Mean (Average): $146K
Data points: 1
$61K
$99K
Data Analyst
Median: $90K
Mean (Average): $83K
Data points: 3
$58K
$100K
Business Analyst
Median: $74K
Mean (Average): $75K
Data points: 52
Business Intelligence*
$63K
Business Intelligence
Median: $63K
Mean (Average): $63K
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 Data Engineer role pays the most with a $145,600 base salary while the Business Intelligence role on average pays the least with a $63,060 base salary.

Discussion & Interview Experiences

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