orders orderNumber INT(11) orderDate DATE requiredDate DATE shippedDate DATE status TEXT comments TEXT customerNumber INT(11) Indexes + customers customerNumber INT(11) customerName VARCHAR(255) contactLastName VARCHAR(255) contactFirstName VARCHAR(255) phone VARCHAR(255) addressLine1 VARCHAR(255) + addressLine2 VARCHAR(255) city VARCHAR(255) state VARCHAR(255) postalCode VARCHAR(255) () country VARCHAR(255) salesRepEmployeeNumber INT(11) creditLimit DECIMAL(8,2) Indexes payments ID INT(11) customer Number INT(11) checkNumber VARCHAR(255) payment Date DATE amount DOUBLE Indexes > orderdetails ID INT(11) orderNumber INT(11) product Code VARCHAR(10) ( quantityOrdered INT(11) priceEach DOUBLE orderlineNumber INT(11) Indexes products product Code VARCHAR(10) productName TEXT productLine VARCHAR(255) productScale TEXT + productVendor TEXT productDescription TEXT quantityInStock INT(11) buy Price DOUBLE MSRP DOUBLE Indexes productlines productLine VARCHAR(255) textDescription TEXT htmlDescription TEXT image TEXT L- -IH Indexes offices employees officeCode INT(11) employeeNumber INT(11) city TEXT lastName TEXT phone TEXT firstName TEXT addressLine1 TEXT extension TEXT addressLine2 TEXT ---- email TEXT state TEXT officeCode INT(11) country TEXT reportsTo TEXT postalCode TEXT job Title TEXT territory TEXT Indexes Indexes 1. Write a query to show customers regardless they have paid any money or not. 2. Write a query to show customers regardless they have ordered any products or not. 3. Write a query to show products regardless they have been ordered or not. 4. Write a query to show employees and customers. 5. Write a query to show countries that customers and employees are from (no duplicates)