Bmw Group Interview Questions

Bmw Group Interview Guides

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

Bmw Group Interview Questions

Practice for the Bmw Group interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Easy

The support team at your company is trying to analyze ticketing data to improve response times. They have noticed that a significant number of tickets have no assigned agent, making it difficult to track the progress of these tickets.

Write a SQL query to count the total number of tickets, the number of tickets assigned to agents, and the number of tickets that are not assigned to any agent.

Note: Tickets that are not assigned to any agent have NULL in their agent_id field.

Example:

Input:

tickets table

Column Type
id INTEGER
issue VARCHAR
agent_id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP

Output:

Column Type
total_tickets INTEGER
tickets_with_agent INTEGER
tickets_without_agent INTEGER
Behavioral
Easy
Data Pipelines
Medium
Loading pricing options

View all Bmw Group questions

Challenge

Check your skills...
How prepared are you for working at Bmw Group?

Bmw Group Salaries by Position

Data Scientist*
$100K
Data Scientist
Median: $100K
Mean (Average): $100K
Data points: 1
$83K
$97K
Software Engineer
Median: $94K
Mean (Average): $91K
Data points: 5

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 Scientist role pays the most with a $100,000 base salary while the Software Engineer role on average pays the least with a $90,877 base salary.

Discussion & Interview Experiences

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