What is wrong with this sql statement

You need to specify the data types for the columns. Also, you don't need those back-tick quotes:

CREATE TABLE bavaria_test (
    Schule int,
    Stasse varchar(100),
    -- etc.
)

The columns are missing data types.

The last column has a extra comma at the end

Remove the trailing comma after Schulnummer. That comma tells it there will be another column in the list, and there is not.

You've defined your column names but not given the columns a data type.

For example, Schule could be defined like:

Schule varchar(50)

which would indicate that the column is a "string" that can hold up to 50 characters.

Assuming you are using MySQL because of ENGINE = MYISAM:

You must read this. You are forgetting to specify the types of each column and you have a extra comma here 'Schulnummer',).