The Database Model
The databse and all the tables are created.
First, you could use SHOW tables; to check the existing tables, and then SELECT * FROM ... to see the data records.
Note that the field UnitsOnOrder in the products table is the product’s total number of units on order from suppliers, whereas the Quantity field in products_orders tables indicates the number of units of a product in a particular customer order. The ProductUnitPrice field in the product table is the price charged to customers. The OrderDate field in the orders table contains only a date, not a specific time of day.
This platform will not save any information, once refresh, everything clears. Please copy your code into the answer book
Questions:
Q1.
Q2.
Use
`TotalOrderAmount` instead of TotalOrderAmount in your query, an unexpected error may occur here. Q3.
Q4: