Home / Expert Answers / Computer Science / list-all-the-countries-from-the-34-offices-34-table-and-the-employees-from-the-34-employees-34-table-pa212

(Solved): - List all the countries from the "OFFICES" table and the employees from the "EMPLOYEES" table. H ...



student submitted image, transcription available below

student submitted image, transcription available belowstudent submitted image, transcription available below
- 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 ), CHECK ((startDate > '2001-10-01')), CONSTRAINT unique person full name UNIQUE (firstName, lastName), firstName gender startDate email officer iobTitle salary CHECK (salary ), FOREIGN KEY (officeCode) REFERENCES OFFICES (officeCode) );


We have an Answer from Expert

View Expert Answer

Expert Answer



We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe