{\rtf1\ansi\deff0\adeflang1025
{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman{\*\falt Thorndale};}{\f1\froman\fprq2\fcharset0 Times New Roman{\*\falt Thorndale};}{\f2\froman\fprq2\fcharset0 Times New Roman;}{\f3\fmodern\fprq1\fcharset0 Courier New;}{\f4\fnil\fprq2\fcharset0 HG Mincho Light J;}{\f5\fnil\fprq2\fcharset0 Arial Unicode MS;}}
{\colortbl;\red0\green0\blue0;\red128\green128\blue128;}
{\stylesheet{\s1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\rtlch\afs24\lang255\ltrch\dbch\af4\afs24\langfe255\loch\f0\fs24\lang1033\snext1 Default;}
{\*\cs3\rtlch\afs24\lang255\ltrch\dbch\af4\afs24\langfe255\loch\f0\fs24\lang1033 Numbering Symbols;}
}
{\info{\author Sharon Tuttle}{\creatim\yr2003\mo2\dy24\hr9\min6}{\operator Sharon Tuttle}{\revtim\yr2003\mo2\dy24\hr9\min30}{\printim\yr1601\mo1\dy1\hr0\min0}{\comment StarWriter}{\vern6410}}\deftab1250
{\*\pgdsctbl
{\pgdsc0\pgdscuse195\pgwsxn12240\pghsxn15840\marglsxn1800\margrsxn1800\margtsxn1440\margbsxn1440\pgdscnxt0 Default;}}
\paperh15840\paperw12240\margl1800\margr1800\margt1440\margb1440\sectd\sbknone\pgwsxn12240\pghsxn15840\marglsxn1800\margrsxn1800\margtsxn1440\margbsxn1440\ftnbj\ftnstart1\ftnrstcont\ftnnar\aenddoc\aftnrstcont\aftnstart1\aftnnrlc
\pard\plain \s1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\rtlch\afs24\lang255\ltrch\dbch\af4\afs24\langfe255\loch\f0\fs24\lang1033\qc\ltrch\loch\fs22\b {\ltrch\loch\f0 HUMBOLDT STATE UNIVERSITY}
\par \pard\plain \s1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\rtlch\afs24\lang255\ltrch\dbch\af4\afs24\langfe255\loch\f0\fs24\lang1033\li420\ri0\fi-420\qc\ltrch\loch\f2\fs22\b {\ltrch\loch\f2 Spring 2003 - CIS 180 L - Section 3 - Intro to SQL}
\par {\ltrch\loch\f2 Homework #1 - Due by 10:00 am on Friday, February 28th}
\par \pard\plain \s1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\rtlch\afs24\lang255\ltrch\dbch\af4\afs24\langfe255\loch\f0\fs24\lang1033\li420\ri0\fi-420\ltrch\loch\f2\fs22 
\par {\ltrch\loch\f2 Precede your answers to each of the following (except for #1! 8-) ) with a SQL comment containing the number of the question being "answered" by that statement / those statements. (for example, {\b\f3 -- question #2} )}
\par 
\par {\ltrch\loch\f2 1.\tab Create a SQL script named {\b 180hw01.sql}. Then, {\b inside}{\b0  of this SQL script:}}
\par 
\par {\ltrch\loch\f2 2.\tab ...begin spooling to an output file named {\b 180hw01_results.txt}{\b0 .}}
\par \pard\plain \s1{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\rtlch\afs24\lang255\ltrch\dbch\af4\afs24\langfe255\loch\f0\fs24\lang1033\li420\ri0\fi-420\ltrch\loch\f2\fs22 
\par {\ltrch\loch\f2 3.\tab ...use {\b prompt} commands to write a line containing your name, and an empty line.}
\par 
\par {\ltrch\loch\f2 4.\tab ...write 3 SQL {\b select } commands that will show the current contents of the tables {\b empl}, {\b dept}, and {\b customer}.}
\par 
\par {\ltrch\loch\f2 5.\tab ...write a SQL statement that will show just the {\b job_title} column of the {\b empl} table.}
\par 
\par {\ltrch\loch\f2 6.\tab ...write a SQL statement that will show just the {\b job_title} column of the {\b empl} table, EXCEPT make sure that there will be {\b no duplicate rows} in your result.}
\par 
\par {\ltrch\loch\f2 7.\tab ...write a SQL statement that will show just the {\b mgr} and {\b job_title} columns of the {\b empl} table.}
\par 
\par {\ltrch\loch\f2 8.\tab ...write a SQL statement that will show just the {\b mgr} and {\b job_title }columns of the {\b empl} table, EXCEPT make sure that there will be {\b no duplicate rows} in your result.}
\par 
\par {\ltrch\loch\f2 9.\tab ...write a SQL statement that will show just the {\b empl_last_name} and {\b mgr} columns of the {\b empl} table, EXCEPT rename the column heading for {\b empl_last_name }to be "Last Name" and rename the column heading for {\b mgr} to be "Mgd by". Make sure that the case is exa
ctly as shown here --- and note that one of the column headings gets cut off in the results! (Do not worry about this now --- we'll talk about how to "fix" this later.)}
\par 
\par {\ltrch\loch\f2 10.\tab ...write a SQL statement that will show just the {\b empl_last_name}, followed by what their salary would be if it were increased by 500.}
\par 
\par {\ltrch\loch\f2{\b0 11.\tab ...write a SQL statement that will show the}{\b  job_title{\b0 , the} empl_last_name}{\b0 ,  and what their {\b salary} would be if it were doubled. Rename the doubled-salary column to be "IF DOUBLED".}}
\par 
\par {\ltrch\loch\f2 12.\tab ...finally, turn spooling off to complete your results file.}
\par 
\par {\ltrch\loch\f2{\b0 Run your script several times, and study the results file carefully until you are satisfied with it. Then, e-mail to me the final versions of your }{\b 180hw01.sql}{\b0  and }{\b 180hw01_results.txt}{\b0 , each in a separate e-mail address whose Subject: line is the name of the
 file, and with the file contents}{\b  included{\b0  in the message,}{\ul  not attache{\b d}{\b0\ulnone .} }}}
\par }