$1.$ Create a view named customer$\_$addresses that shows the shipping and billing addresses for each customer.

This view should return these columns from the Customers table: customer$\_$id$,$ email$\_$address, last$\_$name and first$\_$name.

This view should return these columns from the Addresses table: bill$\_$line$1,$ bill$\_$line$2,$ bill$\_$city, bill$\_$state, bill$\_$zip, ship$\_$line$1,$ ship$\_$line$2,$ ship$\_$city, ship$\_$state, and ship$\_$zip.

$2.$ Create a view named order$\_$item$\_$products that returns columns from the Orders, Order$\_$Items, and Products tables.

This view should return these columns from the Orders table: order$\_$id$,$ order$\_$date, tax$\_$amount, and ship$\_$date.

This view should return the product$\_$name column from the Products table.

This view should return these columns from the Order$\_$Items table: item$\_$price, discount$\_$amount, final$\_$price $($the discount amount subtracted from the item price$),$ quantity, and item$\_$total $($the calculated total for the item$).$

$3.$ Create a view named product$\_$summary that uses the same table you used in in exercise $2.$ This view should return summary information about each product.

Each row should include product$\_$name, order$\_$count $($the number of times the product has been ordered$)$ and order$\_$total $($the total sales for the product$).$

$4.$ Create a view named best$\_$products that uses the same table you used in in exercise $3.$ The view should have the same columns returned. The view should only return the five best selling products by order$\_$total.

I NEED HELP ONLY IN THE LAST QUESTION WHICH IS RELATED TO BEST$\_$PRODUCTS. PLEASE PROVIDE ANSWER TO ONLY $4$TH QUESTION.