SQL SERVER $($SQL FUNCTION CHAPTER$)$ QUERY help.

Please use the data entity and attribute names on the diagram provided. Any help would be greatly appreciated!

Write a SELECT statement that returns these columns from the Order table:

$-$A column that uses the CONVERT function to return the order date column in this format: MM$/$DD$/$YYYY$.$ In other words, use $2-$digit months and days and a $4-$digit year, and separate each date component with slashes.

$-$A column that uses the CONVERT function to return the order date column with the date, and the hours and minutes on a $12-$hour clock with an am$/$pm indicator.

$-$A column that uses the CONVERT function to return the order date column with just the time in a $24-$hour format, including the milliseconds.

$-$A column that uses the CONVERT function to return the order date column with just the month and day.

$\backslash$begin$\{$tabular$\}\{|$l$|$l$|\}\backslash$hline $\backslash$multicolumn$\{2\}\{|$c$|\}\{$ LOCATION $\}\backslash \backslash \backslash$hline PK & LocationID $\backslash \backslash \backslash$hline & LocStreetNum $\backslash \backslash$ LocStree

Hide Transcribed Text

We're unable to fetch the transcribed text right now

Please use the data entity and attribute names on the diagram provided. Any help would be greatly appreciated!