Display a student’s full name along with his/her major’s description.
Use the Indo–US (IU) College database tables to design the following queries. (Use the spooling method to capture all queries and results in the CHAP7SP2.LST file)
```
SQL> SELECT LAST, FIRST, MAJORDESC
2 FROM STUDENT S, MAJOR M
3 WHERE S.MAJORID = M.MAJORID;
LAST FIRST MAJORDESC
--------------- --------------- --------------------------------
DIAZ JOSE AAS-ACCOUNTING
TYLER MICKEY BS-COMPUTER SCIENCE
PATEL RAJESH BS-ACCOUNTING
RICKLES DEBORAH BS-COMPUTER SCIENCE
LEE BRIAN BS-TELECOMMUNICATIONS
KHAN AMIR AAS-COMPUTER SCIENCE
6 ROWS SELECTED.
```
You might also like to view...
Criminal trials are often preceded by a(n) ________ at which the admissibility of evidence is determined
Fill in the blank(s) with correct word
The simplest part of an investigation is analyzing a copy or image for potential evidentiary material. __________
Answer the following statement true (T) or false (F)