Your Android applicationJAVA should have an interface to cre

Your Android application(JAVA) should have an interface to create and save a student table for 5 students. You should save the name of the student and 5 test scores for each student and GPA in database.

Through your interface,

1. you should be able to enter the name of a student and be able to get GPA.

2.  you should be able to get the name of the student with highest GPA

3.   you should be able to get the name of the student with lowest GPA

Example below that shows how to use \'Where\' statement in a query.

selectQuery1 = \"SELECT \" + COLUMN2 + \",\" + \" SUM(\" + COLUMN3 + \")\"

+ \" FROM \" + DATABASE_TABLE2 + \" where \" + COLUMN4

+ \" BETWEEN \" + \"\'\" + toDate + \"\'\" + \" AND \" + \"\'\"

+ fromDate + \"\'\" + \" GROUP BY \" + COLUMN2;

Solution

1. you should be able to enter the name of a student and be able to get GPA.

Select GPA from STUDENT where student_name=\"sateesh\";

2.  you should be able to get the name of the student with highest GPA

SELECT student_name, gpa FROM   student WHERE gpa IN (SELECT MAX(gpa) FROM student);

3.   you should be able to get the name of the student with lowest GPA

SELECT student_name, gpa FROM   student WHERE gpa IN (SELECT MIN(gpa) FROM student);