Redmine

Hi team,
Please help me rebuild these two queries below

Since I’m not very familiar with the naming rules / logic in the schema, I’d really appreciate it if you and the team could review and adjust them.
#1. Original query ++
http://altron.geniee.jp/queries/31670/source?p_start=2025-12-01&p_end=2025-12-10
Request: Need to add "Ad source" (GENIEE SSP/non-GENIEE SSP)
Purpose:
1. Classify revenue:
- Aladdin (GENIEE SSP): revenue from GENIEE SSP traffic
- External: revenue from non-GENIEE SSP traffic
2. Calculate ratios:
- Aladdin Ratio = Aladdin Revenue / Total Revenue
- External Ratio = External Revenue / Total Revenue

#2. Original query ++
http://altron.geniee.jp/queries/31582

Request: Need to add "Ad format", "bidding volume"
Purpose:
- For each ad format, rank demands (Ad networks / DSPs) by bidding volume
- Output should list demand names and their ranking

This is a high-priority task, would you be able to work on it by end of tomorrow?
Sorry for the short notice.
Let me know if you need any further information.
Thank you,
Katie