Please compose the SQL commands that complete the tasks listed below. Please save and submit the SQL commands.

Find the total number of items sold between October $1,2020$ and October $15,2020.$

$\backslash$table$[[,$SUM$($Quantity$)],[,31]]$

Find out the total number of orders that were shipped to an address in California.

$\backslash$table$[[,\backslash$table$[[$Number of orders shipped to$],[$CA$]]],[,4]]$

Find products from the vendor Hasbro that have been put on promotions. List the products by product name and the number of times on promotion. The column name should be shown as Product and Number of Times on Promotion, respectively.

$\backslash$table$[[$Product$,\backslash$table$[[$Number of Times on$],[$Promoition$]]],[$Mr$.$ Potato Head,$1],[$Playskool Magic Tambourine,$2],[$Playskool Honeybee Hop,$1],[$Hungry Hungry Hippos,$1],[$Connect Four,$1],[$Fur Real Friends Biscuit My Lovin Pup,$1]]$

List the name, MSRP$,$ and the lowest promotion price $($i$.$e$.,$ the sales price$)$ for the products with an MSRP greater than $50.$ The lowest promotion price should be less than $$100.$ The column name should be shown as Product, MSRP$,$ and Historical Low respectively.

$\backslash$table$[[$Product$,$MSRP$,\backslash$table$[[$Historical$],[$Low$]]],[$Bridk By Brick,$120,9],[$Little Mommy Real Loving Baby Doll,$80,70],[$Kidizoom Digital Camera $-$ Blue,$70,55],[$Alive Lion Cub Plush Robotic Toy in Tan,$60,50],[$Teaching Cash Register,$60,50]]$