Working Data Types and Handling NULL Values

SQL

Part 1 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