SQL Query from Cape_Codd database

---. These are SINGLE TABLE queries In Cape_Codd 1. Use a SQL query to sum all of the order totals in RETAIL_ORDER. Label the column 'Total Sales' Your output should look like this: Results i Mes Total Sales 1235.00 2. Use a SQL query to both count and sum all of the order totals in RETAIL_ORDER. Label the count of orders 'Total Number Orders' and the sum or orders 'Total Sales Your output should match this: Total Number of Orders Total Sales 1 3 1235.00 3. Display the number which is the maximum quantity on hand out of all of the products in the INVENTORY table. Also display the number which is the minimum quantity on hand in the INVENTORY table. Label the columns as shown in the screenshot below. Your output should match this: Results Messages Highest Inventory Stock Lowest Inventory Stock 1250 0 1 4. Display the number of individual orders that are listed in the ORDER_ITEMS table. Label the columns as shown in the screenshot below. You must query the ORDER_ITEMS to solve this problem, not a different table. Results Messages Number of Orders 1 3 ---. These are SINGLE TABLE queries In Cape_Codd 1. Use a SQL query to sum all of the order totals in RETAIL_ORDER. Label the column 'Total Sales' Your output should look like this: Results i Mes Total Sales 1235.00 2. Use a SQL query to both count and sum all of the order totals in RETAIL_ORDER. Label the count of orders 'Total Number Orders' and the sum or orders 'Total Sales Your output should match this: Total Number of Orders Total Sales 1 3 1235.00 3. Display the number which is the maximum quantity on hand out of all of the products in the INVENTORY table. Also display the number which is the minimum quantity on hand in the INVENTORY table. Label the columns as shown in the screenshot below. Your output should match this: Results Messages Highest Inventory Stock Lowest Inventory Stock 1250 0 1 4. Display the number of individual orders that are listed in the ORDER_ITEMS table. Label the columns as shown in the screenshot below. You must query the ORDER_ITEMS to solve this problem, not a different table. Results Messages Number of Orders 1 3