← Oracle questions

Write SQL schema creation, joins, and group filtering

Filed under Oracle

Write SQL DDL statements to create 'Department' and 'Employee' tables with appropriate primary and foreign key constraints. Then write a SQL query using an INNER JOIN, GROUP BY, and HAVING clause to…

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 Oracle questions

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