JobsJob TrackerJob alerts

ZoomRX ยท 14 questions

All 14Coding 5Low-Level Design 1Behavioral 2Product Sense 1
  • BFS in a grid to mark visited cellsCoding
  • Normalize a table and write aggregate SQL queriesLow-Level Design
  • Robot simulation inside a mazeCoding
  • One edit awayCoding
  • OS functions, processes, threads, deadlock and scheduling
  • Normalization, transitive dependency, 3NF, ACID, joins
  • TCP vs UDP, what happens when you search google.com, DNS, subnetting
  • Data structure types, operation costs, BFS/DFS structures
  • OOP concepts and OOP in real life
  • Rate yourself 1 to 5 on core CS subjects, plus project walkthroughBehavioral
  • Aptitude, CS Concepts, and Coding AssessmentCoding
  • Standard DSA and Core CS TopicsCoding
  • Standard HR QuestionsBehavioral
  • Designing a Rider-Driver Matching AlgorithmProduct Sense
โ† ZoomRX questions
  1. Interview questions
  2. ZoomRX
  3. Normalize a table and write aggregate SQL queries
Low-Level Design

Normalize a table and write aggregate SQL queries

Filed under ZoomRX

The question

Given a table, determine its normal form and normalize it if necessary. Write SQL queries to retrieve students scoring above 50 in any subject without duplicates, and to find student names with an overall average mark greater than 50, for both original and normalized schemas.

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

โ† BFS in a grid to mark visited cellsRobot simulation inside a maze โ†’

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