Untitled

INSERT INTO regions (region_id, region_name) VALUES (1, 'Asia'),(2, 'Americas'),(3, 'Europe');
INSERT INTO countries (country_id, country_name, region_id) VALUES ('IN', 'India', 3),('US','United States', 2),('UK', 'United Kingdom', 2);
INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (1700, '123 Main St', '12345', 'Delhi', 'DL', 'IN'),(1701, '456 Elm St', '54321, Mumbai', 'MH', 'IN'),(1702, '789 Oak St', '67890', 'Bangalore', 'KA', 'IN');
INSERT INTO departments (department_id, department_name, location id) VALUES (1, 'Finance', 1700),(2, Engineering', 1701),(3, 'Sales', 1702);