Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

part 2 sql questions last week need help!?

Write a single query to show the results of the following attempts to cast data:

Casting a date literal to an int data type will display Fail

Casting a date literal to a date data type will display Success

Casting a date literal to int data type will display No if it fails and Yes if it succeeds

Casting a date literal to date data type will display No if it fails and Yes if it succeeds

Take a screen shot of the SQL windows and results and paste it here.

Part 2

Rewrite the query from Part 1 but attempt to parse the data this time instead of cast.

Take a screen shot of the SQL windows and results and paste it here.

Part 3

Using the WideWorldImporters database and the Application schema return the FullName,

PhoneNumber, and CustomFields from the table People. Only return rows where the

CustomFields value contains a NULL. Do not display NULL but the value ‘NONE’

Take a screen shot of the SQL windows and results and paste it here.

Part 4

Assume a select statement is returning fields and the rows may have nulls. Assuming the

following values (NULL, NULL, NULL, ‘This data is okay’) write the query that will insure the

value ‘This data is okay’ is the only value returned.

Take a screen shot of the SQL windows and results and paste it here

There are no answers yet.
Be the first to answer this question.