Main1 cały

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Main1 {
    private static final String QUERY1 = "CREATE TABLE 'users' ( `id` INT NOT NULL , `first_name` VARCHAR(60) NOT NULL , `last_name` VARCHAR(60) NOT NULL , `email` VARCHAR(60) NOT NULL , 'salary' REAL(7,2) NOT NULL, 'sex' INT NOT NULL)";
    private static final String QUERY2 = "CREATE TABLE 'departments' ( `id` INT NOT NULL , `name` VARCHAR(60) NOT NULL )";
    private static final String QUERY3 = "CREATE TABLE 'departments' ( `id` INT NOT NULL , `name` VARCHAR(255) NOT NULL )";
    private static final String QUERY4 = "SELECT AVG(salary) FROM users";
    private static final String QUERY5 = "SELECT MAX(salary) FROM users WHERE id = 2";
    private static final String QUERY6 = "SELECT * FROM users WHERE salary > 5000";

    public static void main(String[] args) {
        try (Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/exam2poprawa?useSSL=false", "root", "coderslab")) {
            PreparedStatement ps = con.prepareStatement(QUERY1);
            ps.executeUpdate();

            ps = con.prepareStatement(QUERY2);
            ps.executeUpdate();

            ps = con.prepareStatement(QUERY3);
            ps.executeUpdate();

            ps = con.prepareStatement(QUERY4);
            ps.executeUpdate();

            ps = con.prepareStatement(QUERY5);
            ps.executeUpdate();

            ps = con.prepareStatement(QUERY6);
            ps.executeUpdate();

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}