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 5. Write a query to show the customer that has the highest number of orders. Hint: use the solution to Q4 in the From Clause. 6. Write a query to show the number of employees in each office. Hint: use a subquery in the SELECT clause. 7. Write a query to show the customers that have not placed any orders. Hint: use a subquery in the WHERE clause. 8. Write a query to show the value of each order. Hint: use a subquery in the SELECT clause