video1.0<iframe src="https://www.loom.com/embed/662f86de5b7246b08d9ebcceb6a1d100" frameborder="0" width="1280" height="960" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>9601280Loomhttps://www.loom.com9601280https://cdn.loom.com/sessions/thumbnails/662f86de5b7246b08d9ebcceb6a1d100-00001.gif297.5899999999999In this video, I explain the advanced SQL query for our inventory database system. I cover various queries such as quantity by products, quantity by categories, sales quantity, revenue, cumulative revenue, average subtotal, state revenue, total revenue, buyer ranking, sales ranking, number one selling product, stock in warehouse, product out of stock, product information, buyer information, price information in each category, and price difference. I provide examples and explain the purpose of each query. Please watch the video to gain a better understanding of our inventory database system.