Create a query that will show the person id and start date for each ref. In your output format the date to show as Mon DD-YYYY. For help with this problem visit the Microsoft website mentioned in the slide presentation. Your output should look like the following

:Person ID Start Date

-----------------------------

160 Aug 23, 2012

161 Aug 23, 2012

162 Aug 23, 2012

Create a query that will the person id, start dateand end date for all players who have none listed as their previous experience. Rather than showing NULL for end date, have the query output No End Date. HINT: To get the Coalesce function to print text, we need to convert the field we are looking at, EndDate. Your output should look like the following:

Person ID Start Date End Date

---------------------------------

119 2012-05-28 No End Date

120 2012-06-12 No End Date

121 2012-07-14 No End Date

123 2012-07-14 No End Date

125 2012-05-28 No End Date

126 2012-07-14 No End Date

128 2012-05-28 No End Date

130 2012-07-14 No End Date

132 2012-05-07 No End Date

133 2012-07-14 No End Date

136 2012-06-12 No End Date

138 2012-05-07 No End Date

139 2012-05-28 No End Date

141 2012-05-28 No End Date

143 2012-08-01 No End Date

145 2012-08-01 No End Date