Untitled

/* 
   1. Count all employees
   2. Return employee name and their department name 
*/


CREATE TABLE departments (
    id NUMBER PRIMARY KEY,
    name VARCHAR2(50)
);

CREATE TABLE employees (
    id NUMBER PRIMARY KEY,
    name VARCHAR2(100),
    department_id NUMBER,
    salary NUMBER,
    CONSTRAINT fk_dept FOREIGN KEY (department_id) REFERENCES departments(id)
);