2024-07-04
Learn coding
00

题目描述:

js
表: Customers +---------------+---------+ | Column Name | Type | +---------------+---------+ | customer_id | int | | name | varchar | +---------------+---------+ customer_id 是该表主键. 该表包含消费者的信息. 表: Orders +---------------+---------+ | Column Name | Type | +---------------+---------+ | order_id | int | | order_date | date | | customer_id | int | | product_id | int | +---------------+---------+ order_id 是该表主键. 该表包含消费者customer_id产生的订单. 不会有商品被相同的用户在一天内下单超过一次. 表: Products +---------------+---------+ | Column Name | Type | +---------------+---------+ | product_id | int | | product_name | varchar | | price | int | +---------------+---------+ product_id 是该表主键. 该表包含所有商品的信息. 写一个解决方案, 找到每件商品的最新订单(可能有多个). 返回的结果以 product_name 升序排列, 如果有排序相同, 再以 product_id 升序排列. 如果还有排序相同, 再以 order_id 升序排列.
首页

PERSONAL SKILL

Proficient in Python, R, SQL, MS Office; English CET-6, can be used for meeting communication and reporting; Basic knowledge of CSS, html, JS.

WORKING EXPERIENCE

Click here to view my CV.