Please do the following Queries for the data in classicmodels database:

$1-$ Display contact First name and contact Last name for customers after sorting the

customers by their contact Last name in ascending order.

$2-$ selects the order line items $($orderNumber$,$ orderlinenumber$)$ from

the $$orderdetails$$ table. Also, display the subtotal $($quantityOrdered $*$ priceEach$)$ for each

line item and sorts the result set based on the subtotal descending $.$

$3-$ Display unique last names from employees table ordered by last name.

$4-$ Display customerNumber, customerName and creditLimit for getting the top five customers

who have the highest creditLimit.

$5-$ Find customer Name, customer country, sales representative employee number from

customers who do not have a sales representative.

$6-$ For each order status, display status and count of orders have this status.

$7-$ For Each order number in order details table, Display order number, sum of quantity

ordered $($itemsCount$)$ and sum of $($priceEach $*$ quantityOrdered$)$ as total. With condition

$$total$$ greater than $1000.$

$8-$ Display product code, product name and text description for product.

$9-$ Find customer number, customer name, order status and order number, for customer

with their orders $($handle customers that don$$t have orders also$).$