- List all the countries from the "OFFICES" table and the employees from the "EMPLOYEES" table. However, give priority to countries that don't have any employees associated with them.
CREATE TABLE OFFICES ( officeCode VARCHAR(10) PRIMARY KEY NOT NULL, city VARCHAR(50) NOT NULL, phone VARCHAR(50) NOT NULL, \begin{tabular}{ll|l|l|l|l|l|l|l|} \hline \end{tabular} addressLine1 VARCHAR(50), state VARCHAR(50), country VARCHAR(50), postalCode VARCHAR(15), roomsize_m2 INTEGER, CHECK (roomsize_m2 >=0) );
CREATE TABLE EMPLOYEES ( employeeNumber INT AUTO_INCREMENT PRIMARY KEY, lastName VARCHAR(50) NOT NULL, firstName VARCHAR(50) NOT NULL, gender TINYINT, startDate DATE, email VARCHAR(100), officeCode VARCHAR(50), iobTitle VARCHAR(80), salary DECIMAL(20,2), CHECK (gender IN (0,1) ), CHECK ((startDate > '2001-10-01')), CONSTRAINT unique person full name UNIQUE (firstName, lastName), firstName gender startDate email officer iobTitle salary CHECK (salary >=0 ), FOREIGN KEY (officeCode) REFERENCES OFFICES (officeCode) );