/* Question 1 */
/* Build a query that shows how many countries have
no State value in the location address. */
/* Question 2 */
/* Build a query showing employee Id, last name and invoice Id
whether the employee is associated with invoices or not.
Sort by employee id */
/* Please save your work now */
/* Please save your work now */
/* Question 3 */
/* Build a query showing the product Id, product description and
the number of times each product ID has appeared in all invoices.
Only show product IDs that showed up 7 times or more.
/* Question 4 */
/* Build a query showing employee Id, and manager Id for
employees who were hired before their manager was hired.
Only include employees who were hired in August and whose
manager Id is 1. */
/* Question 5 */
/* Build a query showing the employee ID and hire date for those
employees who have the same manager as the employee with the
last name: Howard. Exclude those employees who were hired in February
from result. */
/* Question 6 */
/* List employee first name, and job title for those who are managers. In query result
only show job title of Sales Manager. Restriction: an employee who is designated as
a manager has a manager Id value in Manager_ID column. Sort by first name */
/* Question 7 */
/* Build a query showing employee Id, last name, hire date and
experience in months for the employee with the least experience.
Round experience to whole month. Consider month = 30 days */
/* Question 8 */
/* Create a query showing salesman ids and count of invoices each
salesman is associated with. Only display those salesman Ids
associated with 12 invoices or more. Do not display salesman Id
of null values */
/* Question 9 */
/* Build a query showing the number of employees
with job titles that do not have the word stock or accountant
in the job title. Required: utilize the function initcap in query */
/* Question 10 */
/* Build a query showing the product description, category Id,
and product list price for the product that has the lowest list price. */
/* Question 11 */
/* Build a query showing product description and total value per each product
available in inventory. Base calculation on inventory quantity * list price.
Only show total value of $4,000,000
Demonstrate the use of table and column aliasing. */
/* Question 12 */
/* Build a query showing the number of locations in each
country and the number of warehouses per location.
Only show countries with 3 or more locations. */