mysql coding for wordpress woocommerce

i need codes that will query database for the following

history
discounts
current stock value
inventory count
inventory value
fast moving
slow moving
comparison
forecasting
tip
profit
expiration and email notification
closing inventory, items sold, items sold per day, days cover, and average cost.
top sellers, worst sellers, and year-over-year growth
deadstock
cost of goods
taxes, discount etc