Use Common Table Expressions (CTE) to write a query that displays the sum of all purchase orders and sum of all sales orders per each shipping method using the TotalDue column. All shipping methods...

Use Common Table Expressions (CTE) to write a query that displays the sum of all purchase orders and sum of all sales orders per each shipping method using the TotalDue column. All shipping methods must be displayed regardless of whether they have matching sales or purchases. Show the ShipMethodID, name, purchase orders total and sales orders total. Round all values to 2 decimal places. Hint: Use mutliple CTEs. Below is a sample of expected results: