$```$

CREATE TABLE OrderDetails $($

order$\_$detail$\_$id INT PRIMARY KEY AUTO$\_$INCREMENT,

order$\_$id INT,

book$\_$id INT,

quantity INT,

price DECIMAL$(10,2),$

subtotal DECIMAL$(10,2)$ AS $($quantity $*$ price$)$ STORED,

FOREIGN KEY $($order$\_$id$)$ REFERENCES Orders$($order$\_$id$),$

FOREIGN KEY $($book$\_$id$)$ REFERENCES Books$($book$\_$id$)$

$)$;

$```$

I tried inserting without null in insert then get a different error. how do I add multiple books in this table. thanks