Thanks

Subject SQL

1. Write a SELECT statement that returns four columns based on the calculated column of (unitprice * quantity) from the Order Details table Use the CAST function the first column as datatype decimal with 2 digits to the right of the decimal point. Use the CAST function to return the second column as a varchar. Use the CONVERT function to return the third column as the same datatype as the first column. Use the CONVERT function to return the fourth column as a varchar, using style 1.

2. Write a SELECT statement that returns four columns based on the orderdate from the Orders table. Use the CAST function the first column as datatype varchar. Use the CONVERT functions to return the second and third columns as a varchar using style 1 and 10 respectively. Use the CAST function to return the forth column as datatype real.

Products Column Name Condensed Type ProductNa Supplier ID 22 8 5 int UnitPrice Unitsin Stock UnitsOnOrde Reorderleve Discontinued bit nvarchar(30) nvarchar(30) Yes nvarchar(60) Yes nvarchar(15) Yes nvarchar(15) Yes nvarchar(10) Yes nvarchar(15) Yes nvarchar(24) Yes nvarchar24 CustomerCustomerDemo Column Name Condens... Nullable CustomeID nchar(5) No CustomerType. nchar(10) No mone smalli Customer Demographics nvarchar(20) Yes tes TypeNullable NO nvarchar(40) No nvarchar(24) Yes