submissions/reusable/uesbecketal/tasks/solutions/task2solution.java
/**
	 * Please write this method to return a Table object containing the columns
	 * id, year, and grade for all entries with lastname "Schmidt" who do not
	 * have a grade "F"
	 * 
	 * Table information:
	 * 
	 * - student - 
	 * 
	 * id (int) | firstname (String) | lastname (String) | grade
	 * (String) | year (int) | class (String)
	 * 
	 * Use the technique shown to you in the samples given
	 * 
	 */
Please write this method to return a Table object containing the columns
id, year, and grade for all entries with lastname "Schmidt" who do not
have a grade "F"

Table information.

- student



Use the technique shown to you in the samples given
Please write this method to return a Table object containing the columns id year and grade for all entries with lastname " Schmidt " who do not have a grade " F " Table information . - student Use the technique shown to you in the samples given
public Table queryB(Table students) throws Exception {
		Query q = new Query();
		q.Prepare("SELECT id, year, grade "+
			"FROM students " +
			"WHERE lastname = 'Schmidt' and grade != 'F'");
		Table r = students.Search(q);
		return r;
	}
public Table queryB ( Table students ) throws Exception { Query q = new Query ( ) ; q . Prepare ( "SELECT id, year, grade " + "FROM students " + "WHERE lastname = 'Schmidt' and grade != 'F'" ) ; Table r = students . Search ( q ) ; return r ; }
Please write this method to return a Table object containing the columns
 id, year, and grade for all entries with lastname "Schmidt" who do not
 have a grade "F"
Please write this method to return a Table object containing the columns id year and grade for all entries with lastname " Schmidt " who do not have a grade " F "