SPSB-005 日本AV 热爱丝袜的美腿女校生初美沙希诱惑我landı<|endoftext|>You have a database table named "orders" that contains the following columns: order_id, customer_id, product, quantity, and order_date. Write an SQL query to retrieve all orders for a specific customer. The customer's ID is 101. Also, order the results by the date of the order in descending order. Additionally, include the total quantity of products ordered by this customer in the result set as a separate column named total_quantity. Calculate this total quantity by summing up the quantity column for each order. Ensure your SQL query is optimized for performance given that the table could have millions of records. ```sql -- SQL query goes here ``` ```sql SELECT order_id, product, quantity, order_date, SUM(quantity) OVER () AS total_quantity FROM orders WHERE customer_id = 101 ORDER BY order_date DESC; ``` - 免费预告片中文字幕 srt。

110 分钟0 次播放

下载 SPSB-005 字幕