1.)List the names and street addresses of all vendors based in states of Michigan or Ohio. Sort the list by city name.
2.)Find total number of stock items the company have in their warehouse.
3.)Find out the duration (number of days) for which we there are records of sale data. Display the earliest date, latest date and the period between two.
4.)Display the first name and contact details (email, phone) of all 'product specialists' who work in Marketing.
5.)Find the employee number, full name and hire date of oldest staff member.\
6.)Find the date(s) with highest amount of sales. Also display the corresponding total sale amount.\
7.)List all brand names and the total dollar amount of sales for each brand. Sort the list by descending order of brand sales.
8.)Find highest paying customers (according to their invoice totals) and list their names along with the city and state they belong to.
9.)Find out the total of salaries paid out by all departments during the month of June 2017. Sort the list by department name.
10.)For the year 2015, get a list of all professions and their the average salary. Profession is identified employee title. Average must be displayed with 2 decimal places. Sort the list by highest paid jobs at the top.