What SQL questions are asked in Bloomberg interviews?

Technical interviews at Bloomberg cover 20 curated SQL and relational database queries, including joins, window functions, aggregations, and subqueries.

Are SQL questions common for software engineers and data analysts at Bloomberg?

Yes, data engineers, backend engineers, business intelligence analysts, and data scientists at Bloomberg are routinely tested on real-world database query problems.

Bloomberg SQL

Verified

65 SQL queries·40 Easy·22 Medium·3 Hard

Curated SQL and relational database interview problems asked by Bloomberg, ranked by frequency with direct problem links.

DSA (1192)

⌘K

#175Combine Two Tables

Easy·Freq 63%·Acc 79.7%

#1757Recyclable and Low Fat Products

Easy·Freq 54%·Acc 88.6%

#570Managers with at Least 5 Direct Reports

Medium·Freq 50%·Acc 49.2%

#1661Average Time of Process per Machine

Easy·Freq 50%·Acc 66.8%

#176Second Highest Salary

Medium·Freq 50%·Acc 47.5%

#197Rising Temperature

Easy·Freq 50%·Acc 51.6%

#1280Students and Examinations

Easy·Freq 50%·Acc 61.5%

#595Big Countries

Easy·Freq 50%·Acc 68.6%

#1148Article Views I

Easy·Freq 50%·Acc 76.7%

#181Employees Earning More Than Their Managers

Easy·Freq 44%·Acc 73.5%

#1193Monthly Transactions I

Medium·Freq 44%·Acc 59.4%

#1251Average Selling Price

Easy·Freq 41%·Acc 37.5%

#183Customers Who Never Order

Easy·Freq 39%·Acc 72.0%

#577Employee Bonus

Easy·Freq 38%·Acc 77.7%

#584Find Customer Referee

Easy·Freq 38%·Acc 73.1%

#1211Queries Quality and Percentage

Easy·Freq 38%·Acc 53.8%

#180Consecutive Numbers

Medium·Freq 38%·Acc 48.8%

#1174Immediate Food Delivery II

Medium·Freq 38%·Acc 56.4%

#1378Replace Employee ID With The Unique Identifier

Easy·Freq 38%·Acc 83.6%

#1164Product Price at a Given Date

Medium·Freq 38%·Acc 58.1%

#177Nth Highest Salary

Medium·Freq 38%·Acc 39.5%

#626Exchange Seats

Medium·Freq 38%·Acc 74.4%

#1934Confirmation Rate

Medium·Freq 38%·Acc 62.2%

#1070Product Sales Analysis III

Medium·Freq 38%·Acc 46.2%

#182Duplicate Emails

Easy·Freq 38%·Acc 74.0%

#1204Last Person to Fit in the Bus

Medium·Freq 30%·Acc 69.5%

#1581Customer Who Visited but Did Not Make Any Transactions

Easy·Freq 30%·Acc 67.9%

#602Friend Requests II: Who Has the Most Friends

Medium·Freq 30%·Acc 63.0%

#196Delete Duplicate Emails

Easy·Freq 30%·Acc 66.3%

#1321Restaurant Growth

Medium·Freq 30%·Acc 59.2%

#178Rank Scores

Medium·Freq 30%·Acc 68.2%

#1731The Number of Employees Which Report to Each Employee

Easy·Freq 27%·Acc 53.5%

#185Department Top Three Salaries

Hard·Freq 25%·Acc 61.0%

#550Game Play Analysis IV

Medium·Freq 25%·Acc 41.7%

#1789Primary Department for Each Employee

Easy·Freq 25%·Acc 74.8%

#1141User Activity for the Past 30 Days I

Easy·Freq 25%·Acc 51.1%

#262Trips and Users

Hard·Freq 25%·Acc 38.6%

#610Triangle Judgement

Easy·Freq 25%·Acc 74.9%

#620Not Boring Movies

Easy·Freq 25%·Acc 75.1%

#1341Movie Rating

Medium·Freq 25%·Acc 43.8%

#1045Customers Who Bought All Products

Medium·Freq 25%·Acc 64.2%

#1683Invalid Tweets

Easy·Freq 25%·Acc 85.2%

#585Investments in 2016

Medium·Freq 25%·Acc 51.4%

#1978Employees Whose Manager Left the Company

Easy·Freq 25%·Acc 48.8%

#607Sales Person

Easy·Freq 18%·Acc 66.1%

#1075Project Employees I

Easy·Freq 18%·Acc 67.0%

#1517Find Users With Valid E-Mails

Easy·Freq 18%·Acc 35.6%

#1068Product Sales Analysis I

Easy·Freq 18%·Acc 85.9%

#1907Count Salary Categories

Medium·Freq 18%·Acc 64.8%

#619Biggest Single Number

Easy·Freq 18%·Acc 71.6%

#511Game Play Analysis I

Easy·Freq 13%·Acc 76.5%

#1633Percentage of Users Attended a Contest

Easy·Freq 13%·Acc 60.6%

#1667Fix Names in a Table

Easy·Freq 13%·Acc 60.6%

#627Swap Sex of Employees

Easy·Freq 13%·Acc 84.8%

#1158Market Analysis I

Medium·Freq 13%·Acc 57.5%

#1527Patients With a Condition

Easy·Freq 13%·Acc 39.0%

#1084Sales Analysis III

Easy·Freq 13%·Acc 47.9%

#1729Find Followers Count

Easy·Freq 13%·Acc 69.6%

#608Tree Node

Medium·Freq 13%·Acc 76.0%

#3497Analyze Subscription Conversion

Medium·Freq 13%·Acc 74.5%

#1693Daily Leads and Partners

Easy·Freq 13%·Acc 86.7%

#601Human Traffic of Stadium

Hard·Freq 13%·Acc 51.6%

#596Classes With at Least 5 Students

Easy·Freq 13%·Acc 64.3%

#2356Number of Unique Subjects Taught by Each Teacher

Easy·Freq 13%·Acc 89.2%

#1050Actors and Directors Who Cooperated At Least Three Times

Easy·Freq 8%·Acc 0.7%

#	SQL Problem	Difficulty	Frequency↓	Acceptance
#175	Combine Two Tables3 sources	Easy	63%	79.7%
#1757	Recyclable and Low Fat Products3 sources	Easy	54%	88.6%
#570	Managers with at Least 5 Direct Reports3 sources	Medium	50%	49.2%
#1661	Average Time of Process per Machine3 sources	Easy	50%	66.8%
#176	Second Highest Salary3 sources	Medium	50%	47.5%
#197	Rising Temperature3 sources	Easy	50%	51.6%
#1280	Students and Examinations3 sources	Easy	50%	61.5%
#595	Big Countries3 sources	Easy	50%	68.6%
#1148	Article Views I3 sources	Easy	50%	76.7%
#181	Employees Earning More Than Their Managers3 sources	Easy	44%	73.5%
#1193	Monthly Transactions I3 sources	Medium	44%	59.4%
#1251	Average Selling Price3 sources	Easy	41%	37.5%
#183	Customers Who Never Order3 sources	Easy	39%	72.0%
#577	Employee Bonus3 sources	Easy	38%	77.7%
#584	Find Customer Referee3 sources	Easy	38%	73.1%
#1211	Queries Quality and Percentage3 sources	Easy	38%	53.8%
#180	Consecutive Numbers3 sources	Medium	38%	48.8%
#1174	Immediate Food Delivery II3 sources	Medium	38%	56.4%
#1378	Replace Employee ID With The Unique Identifier3 sources	Easy	38%	83.6%
#1164	Product Price at a Given Date3 sources	Medium	38%	58.1%
#177	Nth Highest Salary3 sources	Medium	38%	39.5%
#626	Exchange Seats3 sources	Medium	38%	74.4%
#1934	Confirmation Rate3 sources	Medium	38%	62.2%
#1070	Product Sales Analysis III3 sources	Medium	38%	46.2%
#182	Duplicate Emails3 sources	Easy	38%	74.0%
#1204	Last Person to Fit in the Bus3 sources	Medium	30%	69.5%
#1581	Customer Who Visited but Did Not Make Any Transactions3 sources	Easy	30%	67.9%
#602	Friend Requests II: Who Has the Most Friends3 sources	Medium	30%	63.0%
#196	Delete Duplicate Emails3 sources	Easy	30%	66.3%
#1321	Restaurant Growth3 sources	Medium	30%	59.2%
#178	Rank Scores3 sources	Medium	30%	68.2%
#1731	The Number of Employees Which Report to Each Employee3 sources	Easy	27%	53.5%
#185	Department Top Three Salaries3 sources	Hard	25%	61.0%
#550	Game Play Analysis IV3 sources	Medium	25%	41.7%
#1789	Primary Department for Each Employee3 sources	Easy	25%	74.8%
#1141	User Activity for the Past 30 Days I3 sources	Easy	25%	51.1%
#262	Trips and Users3 sources	Hard	25%	38.6%
#610	Triangle Judgement3 sources	Easy	25%	74.9%
#620	Not Boring Movies3 sources	Easy	25%	75.1%
#1341	Movie Rating3 sources	Medium	25%	43.8%
#1045	Customers Who Bought All Products3 sources	Medium	25%	64.2%
#1683	Invalid Tweets3 sources	Easy	25%	85.2%
#585	Investments in 20163 sources	Medium	25%	51.4%
#1978	Employees Whose Manager Left the Company3 sources	Easy	25%	48.8%
#607	Sales Person3 sources	Easy	18%	66.1%
#1075	Project Employees I3 sources	Easy	18%	67.0%
#1517	Find Users With Valid E-Mails3 sources	Easy	18%	35.6%
#1068	Product Sales Analysis I3 sources	Easy	18%	85.9%
#1907	Count Salary Categories3 sources	Medium	18%	64.8%
#619	Biggest Single Number3 sources	Easy	18%	71.6%
#511	Game Play Analysis I3 sources	Easy	13%	76.5%
#1633	Percentage of Users Attended a Contest3 sources	Easy	13%	60.6%
#1667	Fix Names in a Table3 sources	Easy	13%	60.6%
#627	Swap Sex of Employees3 sources	Easy	13%	84.8%
#1158	Market Analysis I3 sources	Medium	13%	57.5%
#1527	Patients With a Condition3 sources	Easy	13%	39.0%
#1084	Sales Analysis III3 sources	Easy	13%	47.9%
#1729	Find Followers Count3 sources	Easy	13%	69.6%
#608	Tree Node3 sources	Medium	13%	76.0%
#3497	Analyze Subscription Conversion3 sources	Medium	13%	74.5%
#1693	Daily Leads and Partners3 sources	Easy	13%	86.7%
#601	Human Traffic of Stadium3 sources	Hard	13%	51.6%
#596	Classes With at Least 5 Students3 sources	Easy	13%	64.3%
#2356	Number of Unique Subjects Taught by Each Teacher3 sources	Easy	13%	89.2%
#1050	Actors and Directors Who Cooperated At Least Three Times2 sources	Easy	8%	0.7%

Showing 65 of 65 SQL questions in All TimeCompany Total: 65 SQL questions