Home

Welcome to the treasure-academy-SQL wiki!

SELECT ... WHERE TD_TIME_RANGE(time, "2013-01-01 JST", "2014-01-01 JST")

month	member_id	goods_id	sub_category	category	amount	sales
2015-02-01	2084822	593901	Musical Instruments	Movies and Music and Games	1	2839
2015-02-01	1400295	594055	Baby	Clothing and Shoes and Jewelry	1	1000
2015-02-01	2084837	586278	Books	Books and Audible	1	2839
2015-02-01	111442	593933	Wedding Registry	Home and Garden and Tools	1	2848