1. for how much minted over time I sum all amout of goBTC and goETH that's sended by algomint wallet (for decimal part i get number of decimal from asset table)

2. about question How many wallets have minted goBTC and goETH? if we want to know all unique wallet that's mint one or both this token, we can use this table

3. for this question we sum all of transaction of goBTC and goETH that sended to algomint wallet. this show that user wants to redeem their original asset in main network (for decimal part I get number of decimal from asset table)

4. if we want to know how many goETH and goBTC in circulation we just need substract amout's fron table question 1 and 3. very easy!!. in this query i create two table mint and redeem and substact their value

5. TL;DR : yes we can redeem portion amount. this is hard one. in this question we want to know is there any redeem amount that lower than mint amout. if we find this ,we taht user can redeem portion of assets. in query part i just mints and redeems table .find user's have both redeem and mint transaction ,if compare redeem and mint amount then for these mint amount bigger than redeem we insert true in is_portion_redeem variable. at the end we query in is_portion_redeem table and if there is true in table this show there is at least one user that redeem portion amount of minted value

Paragraph

6. for Bonus part some extra work need to do . first get block timestamp. as default there isn't timestamp in asset_transaction table for we need to cross this table with block table and get timestamp. after that, as always we find mints and redeem table. then we find user that redeem exact same amout of their mint. than calculation diffrent between mint and redeem timestamp ( in this query i get diffrent as days ) then calc avg between this user