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...
WPA is a much stronger security protocol than ________
Fill in the blank(s) with correct word
A ______________ is a variable that helps control the number of times that a set of statements will execute.
a) repeater b) counter c) loop d) repetition control statement
You cannot update or refresh PivotTable report data
Indicate whether the statement is true or false
Which rule remains unchanged in every computer investigation?
a. encrypt all notes b. search every single file c. pull the battery d. document