生成报告时GROUP BY子句问题

我正在使用SQL数据库在IntelliJ中编写Java应用程序以进行约会处理。对于一部分，我必须生成3种类型的报告：按月列出的约会类型数，每个顾问的时间表以及今年的约会总数。我以前可以进行此工作（并且没有做任何更改），现在它在前两个报告生成中返回错误：

Error Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'U07sym.appointment.start' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

和

Error Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'U07sym.appointment.description' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

我尝试了一些建议，但它们似乎需要“超级”访问权限，并且由于这是我学校托管的数据库，因此我没有该访问权限。

这是1,2和3报告生成器的代码：

public void generateFirstReport() {

    try {
        
        Statement statement = DBConnection.getConnection().createStatement();
        String appointmentTypeQuery = "SELECT description, MONTHNAME(start) as 'Month', COUNT(*) as 'Total' FROM appointment GROUP BY description, MONTH(START)";
        
        ResultSet appointmentQueryResults = statement.executeQuery(appointmentTypeQuery);
        
        StringBuilder parseReport = new StringBuilder();
        
        parseReport.append(String.format("%1$-60s %2$-60s %3$s \n", "Month", "Appointment Type", "Total"));
        parseReport.append(String.join("", Collections.nCopies(163, "-")));
        parseReport.append("\n");
        
        while(appointmentQueryResults.next()) {
            
            parseReport.append(String.format("%1$-56s %2$-60s %3$s \n", appointmentQueryResults.getString("Month"), appointmentQueryResults.getString("description"), appointmentQueryResults.getInt("Total")));
        }
        
        typesOfMonthsText.setText(parseReport.toString());
    }
    
    catch(SQLException ex) {
        System.out.println("Error " + ex.getMessage());
    }
}
    
public void generateSecondReport() {
    
    try {
        
        Statement statement = DBConnection.getConnection().createStatement();
        String consultantQueryResults = "SELECT appointment.contact, appointment.description, customer.customerName, start, end " + "FROM appointment JOIN customer ON customer.customerId = appointment.customerId " +
                "GROUP BY appointment.contact, MONTH(start), start";
        
        ResultSet appointmentQueryResults = statement.executeQuery(consultantQueryResults);
        
        StringBuilder parseReport = new StringBuilder();
        parseReport.append(String.format("%1$-45s %2$-45s %3$-45s %4$-45s %5$s \n", "Consultant", "Appointment", "Customer", "Start", "End"));
        parseReport.append(String.join("", Collections.nCopies(163, "-")));
        parseReport.append("\n");
        
        while(appointmentQueryResults.next()) {
            
            parseReport.append(String.format("%1$-37s %2$-50s %3$-35s %4$-35s %5$s \n", 
                appointmentQueryResults.getString("contact"), appointmentQueryResults.getString("description"), appointmentQueryResults.getString("customerName"),
                appointmentQueryResults.getString("start"), appointmentQueryResults.getString("end")));
        }
        
        scheduleOfConsultantText.setText(parseReport.toString());         
        
    }
    catch(SQLException ex) {
       System.out.println("Error " + ex.getMessage()); 
    }       
}

public void generateThirdReport () {
    
    try {
        Statement statement = DBConnection.getConnection().createStatement();
        //"SELECT description, MONTHNAME(start) as 'Month', COUNT(*) as 'Total' FROM appointment GROUP BY description, MONTH(START)";
        String appointmentQueryResults = "SELECT YEAR(start) as 'Year', COUNT(*) as 'Total' FROM appointment GROUP BY YEAR(start)";
        
        ResultSet yearlyQueryResults = statement.executeQuery(appointmentQueryResults);
        
        StringBuilder parseReport = new StringBuilder();
        parseReport.append(String.format("%1$-50s %2$-50s \n", "Year", "Total"));
        parseReport.append(String.join("", Collections.nCopies(163, "-")));
        parseReport.append("\n");
        
        while(yearlyQueryResults.next()) {
            
            parseReport.append(String.format("%1$-50s %2$-50s \n", yearlyQueryResults.getString("Year"), yearlyQueryResults.getString("Total")));
        }
        
        totalAppointmentsThisYearText.setText(parseReport.toString());
    }
    
    catch(SQLException ex) {
        System.out.println("Error " + ex.getMessage());
    }
}