Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Filing And Computer Database Projects

Authors: Jeffrey Stewart

2nd Edition

007822781X, 9780078227813

More Books

Students also viewed these Databases questions