SQL simple problem case

Hi I need help with this easy SQL problem.
I have attached also the table picture

I need the SQL code used to find the answer
Problem

Now we have two tables on streamers information:
Table a: streamer_info (describing the streamer basic information)
anchor_id
country_code
join_date
streamer uid

the country where the streamer belongs to
date that the streamer joined Fill - Foll
string
two character string. e.g. ID/TH/VN...
yyyyddmm
Table b: live_info (describing the live information of streamers that go live on each day)
note: this table only contains anchors who go live
date
anchor_id
live_duration(mins)
revenue
Live date of the streamer
streamer uid

the duration that the streamer goes live
gifts that the streamer received
yyyyddmm



Questions:
1. There are a lot of streamers joining every day. Fill-Foll Live operator needs to assess the monthly performance of streamers. A qualified streamer has to meet the following standards:
1. Go live for at least 10 days in 1 month
2. Live duration meets 20 hours in 1 month
3. Revenue in 1 month reach 1000
Please help TT Live operator from Indonesia (ID) to find the number of all qualified streamers in January who joined TT from 2021.12.15 to 2021.12.31.

2. Find the list of top 5 streamers (rank by revenue) from each country in January

3. 【Additional Question】
In order to receive a monthly "perfect attendance bonus", a streamer needs to go live for 20 consecutive days (e.g. go live every day from 1.1-1.20, there cannot be any gap in between. If one goes live from 1.1-1.19, and does not go live on 1.20, he will not be qualified ). Please help the Vietnam (VN) operator to find out the list of streamers that can receive the "perfect attendance bonus" in January.