public int numberOfStudents(String name) {
		try{
	        	openDatabase();
	    }catch(Exception e){}
		
		String query = "SELECT COUNT(*) FROM t8005t2 .takes WHERE ID IN (SELECT ID FROM t8005t2 .modules WHERE name= '"
				+ name + "')";
		int count = 0;
		try {
			stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(query);
			while (rs.next()) {
				count = rs.getInt("COUNT(*)");
			}
		} catch (Exception e) {
			System.err.println("Problem executing numberOfStudents query");
			System.err.println(e.getMessage());
		}
		try{
			closeDatabase();
		}catch(Exception e){}
		
		return count;
	}