写一段SQL，已知衬衫表SHIRTABLE，请你实现通过窗口函数实现，根据不同的衬衫种类shirt_type，按照销售单价shirt_price从低到高的顺序创建排序表（C） A SELECT shirt _name, shirt_type, shirt _price，RANK (PARTITION BY shirt _type ORDER BY shirt _price) AS rankingFROM SHIRTABLE B SELECT shirt _name, shirt_type, shirt _price，PARTITION BY shirt _type ORDER BY shirt _price AS rankingFROM SHIRTABLE C SELECT shirt_name, shirt_type, shirt_price，RANK() OVER (PARTITION BY shirt _type ORDER BY shirt_price) AS rankingFROM SHIRTABLE D SELECT shirt _name, shirt_type, shirt _price，RANK() OVER (PARTITION BY shirt_type) AS rankingFROM SHIRTABLE