Some of the rows the GRADES table are below: ​ CODE NAM…

Some of the rows the GRADES table are below: ​ CODE NAME GPA YEAR 938 ALEX 3.1 2 931 MICHELLE 2.3 1 182 JOE 3.1 3 918 ADELE 2.9 2   Which of the following queries returns the name of all the students that achieved the maximum GPA among all the students?  

Some rows of the tables SALESPERSON and SALES are shown belo…

Some rows of the tables SALESPERSON and SALES are shown below:   SALESPERSON VCODE NAME 7 Alex 8 Tony 9 Charles 11 Mary     SALES SCODE VCODE TOTAL 341 9 19.50 213 11 89.95 312 7 31.10 You want the name of all the salespersons that have made at least one sale with a total higher than 100.   Which of the following queries gives the desired result?  

Consider the following table:   TABLE1 val1 val2 val3…

Consider the following table:   TABLE1 val1 val2 val3 3 129 10 2 391 30 12 89 30 5 129 20 90 12 10 12 10 20   What is the result of the query below?   SELECT * FROM TABLE1 WHERE val2 BETWEEN         (100, 400) AND val3 IN (10, 20)