JobsJob TrackerJob alerts

Optum (UnitedHealth Group) ยท 242 questions

All 242Coding 141System Design 11Low-Level Design 12Behavioral 27Product Sense 6
  • Project Management Scenario
  • Student registration management system designSystem Design
  • 2-D array sorting and AVL tree balancingCoding
  • Situational judgment and past internship cultureBehavioral
  • Find index with equal left and right sumsCoding
  • Implement queue using stacksCoding
  • Find minimum value in a binary treeCoding
  • Database design and SQL queriesLow-Level Design
  • Fit squares in a triangleProduct Sense
  • Wildcard character matchingCoding
  • Machine Learning fundamentals and comparisonLow-Level Design
  • Aptitude and Coding AssessmentCoding
  • Project Tech Stack DiscussionBehavioral
  • Project discussionBehavioral
  • Dining Philosophers Problem
  • Delete vs Truncate and IndexingLow-Level Design
  • Puzzles: Mislabeled Jars and Fast Horses
  • Types of TestingLow-Level Design
  • Transition from Dev to QABehavioral
  • Resource Allocation ScenarioBehavioral
  • Database Normalization and Joins
  • Inversion Count and Password checkingCoding
  • Sorting algorithms and DBMS questions based on projectsCoding
  • Minimum number of races for 25 horses to find top 3
  • Simplify Chain of Payments and TransactionsSystem Design
  • Database Scaling, Indexing, Joins and Duplicate TuplesSystem Design
  • Write two MySQL queriesLow-Level Design
  • Java and OOPs Concepts
  • Students starting with T in CSE stream
  • Internet of Things (IoT) principles and applications
  • JSON vs XML trade-offs and usage
  • Project Discussion and DBMS QueriesBehavioral
  • Sentiment analysis on flood tweetsProduct Sense
  • OOP ConceptsLow-Level Design
  • Sort array and find sum of consecutive differencesCoding
  • Implement Bubble SortCoding
  • Design a Vending MachineSystem Design
  • Reverse an array and find substrings divisible by 11Coding
  • Find duplicates in an array with optimizationsCoding
  • Design database schema and write inner join queryLow-Level Design
  • Difference between Java and C++ OOPsLow-Level Design
  • Optum motivation and candidate selection fitBehavioral
โ† Optum (UnitedHealth Group) questions
  1. Interview questions
  2. Optum (UnitedHealth Group)
  3. Write two MySQL queries
Low-Level Design

Write two MySQL queries

Filed under Optum (UnitedHealth Group)

The question

Write SQL queries based on two given problem statements.

No write-up yet. Related questions below have one.

Related Optum (UnitedHealth Group) questions

  • Public fields versus private fields with getters and setters
  • Design a system for an online milk vendor with coupons and price alerts
  • Write an algorithm for traffic light control
  • ACID properties and Normalization forms
  • Machine Learning fundamentals and comparison
โ† Database Scaling, Indexing, Joins and Duplicate TuplesJava and OOPs Concepts โ†’

Collected from public candidate posts and coding forums. Updated Nov 2026.