hanuke.sql

select
	a.*
	, (
		select
			score
		from test_table
		where min <= diff
		and max >= diff
	) as s
	, (
		select
			rank
		from test_table
		where min <= diff
		and max >= diff
	) as r
from (
	select
		a.*
		, (julianday(Date('now')) - julianday(date(test_date))) as diff
	from test_target a
) a
;
select
	diff + 1 as hanuke
from (
	select 
	  rank, min as diff, score
	from test_table
	union all
	select 
	  rank, max as diff, score
	from test_table
	order by rank
)
where (diff + 1) NOT IN (
	select 
	  min as diff
	from test_table
	union all
	select 
	  max as diff
	from test_table
)
and diff < (
	select max(max)
	from  test_table
)
;