您可以将Union查询的结果与另一列的SUM合并吗？

Question

Would this statement work fine even though the Quantity column is decimal(10,4) while the price column is decimal(8,2)?

"(SELECT `price` FROM `"
.$this->symbol."Trades` ORDER BY `TS` DESC LIMIT 1) UNION (SELECT "
."`price` FROM `".$this->symbol."Trades` WHERE `TS` >="
." DATE_SUB(NOW(), INTERVAL 1 DAY) ORDER BY `TS` ASC LIMIT 1) UNION"
." (SELECT SUM(`Quantity`) AS volume FROM `".
$this->symbol."Trades` WHERE `TS` >= DATE_SUB(NOW(), INTERVAL 1 DAY))"