select dd.band, dj.snr-dd.snr as difference, dd.snr as dd_snr, dj.snr as dj_snr, dd.distance, dd.azimuth, dd.rx_sign, dd.time, dd.* from (
select
    snr, tx_sign,
    rx_sign,
    time
from wspr.rx where
	time > '2025-04-05 13:00:00'
    and time < '2025-04-05 20:05:00'
	and tx_sign = 'DJ3EI'
) as dj, (
select
    *
from wspr.rx where
	time > '2025-04-05 13:00:00'
    and time < '2025-04-05 20:05:00'
	and tx_sign = 'DD4TR'
) as dd where
dd.rx_sign = dj.rx_sign and dd.time = dj.time
order by dd.time desc
