Question: What would I type in sql to get this Create a query that will the person id, start date and end date for all players

What would I type in sql to get this  What would I type in sql to get this Create a
query that will the person id, start date and end date for

Create a query that will the person id, start date and end date for all players who have 'none' listed as their previous experience. Rather than showing NULL for end date, have the query outp End D looking at, EndDate. Your output should look like the following: ate'. HINT: To get the Coalesce function to print text, we need to convert the field we are 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!