Given the following database, please answer the following

$6-47.$ Modify P&E $6-46$ to include only those product lines the average price of which is higher than $$200.$

$6-48.$ List the names and number of employees supervised $($label this value HeadCount$)$ for each supervisor who supervises more than two employees.

$6-49.$ List the name of each employee, his or her birth date, the name of his or her manager, and the manager's birth date for those employees who were born before their man$-$ ager was born; label the manager's data Manager and ManagerBirth. Show how you constructed this query using a Venn or other type of diagram.

$6-50.$ Write an SQLquery to display the order number, customer number, order date, and items ordered for some particular customer.

$6-51.$ Write an SQL query to display each item ordered for order number $1,$ its standard price, and the total price for each item ordered.

$6-52.$

Write and SQL Query to dipsplay the total number of employees working at each work center $($include ID and location for each work center$).$

$6-53.$

Write an SQL query that lists those work centers that employ at least one person who has the skill $\text{'}$QCl$\text{'}.$

$6-54.$

Write an SQL query to total the cost of order number$1.$

$6-55.$

Write an SQL query that lists for each vendor $($including vendor lD and vendor name$)$ those materials that the ven$-$ dor supplies where the supply unit prices is at least four

$6-56.$

Calculate the total raw material cost $($label TotCost$)$ for each product compared to its standard product price. Display product ID$,$ product description, standard price, and the total cost in the result.