Count the number of employees by their job title (emp_title). Sort the output by the ascending order
Question:
Count the number of employees by their job title (emp_title). Sort the output by the ascending order
of the job title.
(ii) Write a query to display product type, count of products, and the average product price by product
type.
(iii) Write a query to display the eight departments and their manager's first name, last name, and phone
number of those employees (managers) who were hired after January 01, 1990. Sort the output by
the descending order of department name.
(iv) Write a query to display the department name, department Mailbox, department phone#, the number
of employees in each department, and the average employee tenure as of today. Sort the output by
the department name (ascending order).
(v) List the vendor code, vendor name, and PROD_SKU for products with a quantity on hand that is
less than the minimum quantity. Sort the output by vendor name (ascending).
(vi) Write a query to display a brand name, average product price, max product price, min product price,
price range (i.e., the difference between max price and min price), and the number of products of
that brand that are in the database. Sort the output by the brand name (ascending).
(vii) Write a query to display the sum of all invoice totals and customer balance by the customer state.
Sort the output by descending order of customer balance.
(viii) Write a query to display vendor name, brand name, brand type, and the number of products and
average product price of each brand supplied by the vendor. Sort the output by the vendor name
ascending and the brand name ascending.
(ix) Write a query to display the employee ID, first name, last name, current salary and the starting salary
of each employee. Sort the output by the last name and then by first name (ascending).
(x) Show the sum of the total invoice by employee name (first and last) and the invoice year. Sort the
output by the ascending order of employee name (first and last) and invoice year.