← Amazon questions
CodingReported in a candidate post, Oct 2022

Create two related tables and count employees per department

Filed under Amazon

SQL round, in several parts: 1) Create two related tables with suitable attributes and correct primary and foreign keys (for example Department and Employee). 2) Write a query that counts the number…

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Amazon questions

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