You can see realtions between tables diagram below
COM_Order -> COM_OrderItem (OrderItemOrderID = OrderID)
COM_OrderItem -> COM_SKU (OrderItemSKUID = SKUID)
I hope it helps,
You can generate custom report with SQL,
but there are multiple reporting in "Store Reports"
It might be the one "Top Products by number of purchases" what you are looking for.