Excellus Blue Cross Blue Shield Interview Questions

Excellus Blue Cross Blue Shield Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(10)
SQL
(6)
Statistics
(6)
Behavioral
(5)
Data Structures & Algorithms
(4)

Excellus Blue Cross Blue Shield Interview Questions

Practice for the Excellus Blue Cross Blue Shield interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

Write a SQL query to create a histogram of the number of comments per user in the month of January 2020.

Note: Assume bin buckets class intervals of one.

Note: Comments that were created outside of January 2020 should be counted in a “0” bucket

Example:

Input:

users table

Columns Type
id INTEGER
name VARCHAR
created_at DATETIME
neighborhood_id INTEGER
mail VARCHAR

comments table

Columns Type
user_id INTEGER
body VARCHAR
created_at DATETIME

Output:

Column Type
comment_count INTEGER
frequency INTEGER
SQL
Medium
Statistics
Easy
Loading pricing options

View all Excellus Blue Cross Blue Shield questions

Challenge

Check your skills...
How prepared are you for working at Excellus Blue Cross Blue Shield?

Excellus Blue Cross Blue Shield Salaries by Position

Software Engineer*
$65K
Software Engineer
Median: $65K
Mean (Average): $65K
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 Software Engineer role pays the most with a $65,000 base salary while the Software Engineer role on average pays the least with a $65,000 base salary.

Discussion & Interview Experiences

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