what's wrong with this code?

Question

Hi this is my code which will not work correctly ! what is wrong with its data type :( thanks

CREATE TABLE T1 (A INTEGER NOT NULL);
CREATE TABLE T3 (A SMALLINT NOT NULL);
INSERT T1 VALUES (32768.5);
SELECT * FROM T1;
INSERT T3 SELECT * FROM T1;
SELECT * FROM T3;

Answer 1

32768.5 is not an integer, and it's too big to fit in a smallint.