Q:

How to find data for last 20 tuesdays

I want to find data for the last 20 Tuesday.
        Date                    value
2020-03-03 01:12:15               5
2020-02-25 07:12:15               13
2020-02-24 08:12:15               1
2020-02-23 09:12:15               32
2020-02-22 10:12:15               7
2020-02-21 11:12:15               43
2020-02-20 12:12:15               7
2020-02-19 13:12:15               1
2020-02-18 14:12:15               31
2020-02-17 15:12:15               14

and so one
My desired output is 
        Date                    value
2020-03-03 01:12:15               5
2020-02-25 07:12:15               13
2020-02-18 14:12:15               31

and so on

A:

Is this what you want?
select t.*
from t
where weekday(date) = 2
order by date desc
limit 3  -- or 20

