Provide precise and complete SQL code to answer the question…
Questions
Prоvide precise аnd cоmplete SQL cоde to аnswer the questions below. You should report vаlues in the order in which they are listed in the question and with no additional values beyond what is requested. The following questions (Q22-Q26) refer to the schema depicted in the Appendix below that contains 2 tables (i.e., student and application) having the columns named in bold and values shown below the column names.Assume that VARCHAR data type is used for all attributes except ‘GPA’ and ‘sizeHS’ which use the DECIMAL data type. student sID sName GPA sizeHS 123 Amy 3.90 1000 234 Bob 3.60 1500 345 Craig 3.50 500 456 Doris 3.90 1000 543 Craig 3.40 2000 567 Edward 2.90 2000 654 Amy 3.90 1000 678 Fay 3.80 200 765 Jay 2.90 1500 789 Gary 3.40 800 876 Irene 3.90 400 987 Helen 3.70 800 application aID cName major admitted sID 1 Emory ISDS Y 123 2 LSU CS Y 123 3 LSU EE N 123 4 Tulane CS Y 123 5 UT Austin EE Y 123 6 Tulane biology N 234 7 Emory bioengineering Y 345 8 UT Austin bioengineering N 345 9 UT Austin CS Y 345 10 UT Austin EE N 345 11 Emory CS N 543 12 LSU history Y 678 13 LSU history Y 765 14 UT Austin history N 765 15 UT Austin psychology Y 765 16 Emory biology Y 876 17 Emory marine biology N 876 18 LSU CS N 876 19 LSU CS Y 987 20 Tulane CS Y 987