此為高師大軟體系二年級 411077016-張竣翔 與 軟體系二年級 411077028-李泓逸 的資料庫期末報告。
schema.sql
1. Find the customer who has bought the most (by price) in the past year.
2. Find the top 2 products by dollar-amount sold in the past year.
.png)
3. Find those products that are out-of-stock at every store in Kaohsiung.
4. Find those packages that were not delivered within the promised time.
.png)
5. Assume the package shipped by USPS with tracking number 123456 is reported to have been destroyed in an accident.
Find the contact information for the customer. Also, find the contents of that shipment and create a new shipment of replacement items.
.png)
分別對顧客、客服人員、倉庫管理員所做的app
.png)
.png)
.png)
