单选题 — 写一段SQL，已知衬衫表SHIRTABLE，请你实现通过窗口函数实现，根据不同的衬衫种类shirt_type，按照销售单价shirt_price从低到高的顺序创建排序表（D） 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，RANK() OVER (PARTITION BY shirt_type) AS rankingFROM SHIRTABLE C、SELECT shirt _name, shirt_type, shirt _price，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 ORDER BY shirt_price) AS rankingFROM SHIRTABLE