@Override
    public void initialize(URL url, ResourceBundle rb) {

        try {   //we should fix this query AND WHILE LOOP
            conn = Tables.getConnection();
            List<LeaseReportEntry> apps = new ArrayList<>();
            Statement getRev = conn.createStatement();
            ResultSet rev = getRev.executeQuery(LEASE_REPORT_QUERY);

            int i = 0;
            if(!rev.next()){
                messages.setText(EMPTY_QUERY_MSG);
            }//end if
            else{
                do{
                    Month m;
                    month = rev.getString("Month");
                    cat = rev.getString("Category");
                    num = rev.getString("apt_count");
                    if(month.equals("August")) {
                        m = AUGUST;
                    } else if(month.equals("September")) {
                        m = SEPTEMBER;
                    } else if(month.equals("October")) {
                        m = OCTOBER;
                    } else {
                        m = JULY;
                    }
                    apps.add(new LeaseReportEntry(m, cat, num));
                    System.out.println(apps.get(i));
                    i++;
                }//end do
                while(rev.next());
            }//end else
            /*
            while(rev.next()) {
                month = rev.getString("Month");
                cat = rev.getString("Category");
                num = rev.getString("apt_count");

                apps.add(new LeaseReportEntry(month, cat, num));
                System.out.println(apps.get(i));
                i++;
            }
            */
            getRev.close();
            monthCol.setCellValueFactory(
                new PropertyValueFactory<>("month"));
            categoryCol.setCellValueFactory(
                new PropertyValueFactory<>("category"));
            numberCol.setCellValueFactory(
                new PropertyValueFactory<>("apt_count"));
            monthCol.setSortType(TableColumn.SortType.ASCENDING);
            data.addAll(apps);
            leaseReport.setItems(data);
            leaseReport.getSortOrder().add(monthCol);
        } catch (SQLException ex) {
            System.out.println("SQL Error: " + ex.getMessage());
        }
    }//end method initialize