Question: This is a simplified ER diagram of my database: What I’d like to retrieve is, for each vendor_item: The highest price (excluding the last capture) The lowest price (excluding the last capture) The current price (i.e. the last capture) ...

Question: Let’s say I have two tables as following: SECOND TABLE: I want to join two tables and based on FScore find out top 3 88 and top 3 77 rows like: Any helps are appreciated! Answer: You can use ...