SELECTuser_nameAS購入者,item_nameAS商品名,total_priceAS購入額,dateAS購入日FROM(SELECTu.nameASuser_name,i.nameASitem_name,i.price*o.quanityAStotal_price,o.date,ROW_NUMBER()OVER(PARTITIONBYu.nameORDERBYo.dateDESC)ASrankFROMordersASoINNERJOINusersASuONu.id=o.user_idINNERJOINitemsASiONi.id=o...