(Solved) : List Items Sold Least 30 Cost Month December Hint Use Function Month Date Return Month Dat Q37614628 . . . .

1. List all items that were sold for at least 30% more than costin the month of December. Hint: Use the function MONTH(date) toreturn the month of a date.
2. List the inventory category and total quantity (by eachcategory) ordered in the year 2015 (in descending order of totalquantity). Hint: Use the function YEAR(date) similar toMOMTH(date).
3. List the Spring products ordered by florists that had a listprice over $200.

[Watch: (1) Join MANY tables!! (2)same field name appear in multiple tables; (3) same field name inmultiple tables could mean different things!!]

4. [This problem has TWO questions] List the customer ID and totalorders
   OR

    

   PayPal Gateway not configured

   OR

    

   PayPal Gateway not configured