以下是相关表格的定义:
CREATE TABLE IF NOT EXISTS pricehistory (
id INTEGER(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
price INTEGER NOT NULL,
region VARCHAR(20) NOT NULL,
timestamp TIMESTAMP NOT NULL,
is_from_api INTEGER DEFAULT 0)
下面是有争议的查询:
SELECT MAX(price) AS price
FR