Tag: Murach’s SQL for SQL Server

Murach’s SQL for SQL Server – Exercise 8 – Guaranteed 100% Score 1. Write a SELECT statement that returns four columns based on the InvoiceTotal column of the Invoices table: Use the CAST function to return the first column as data type decimal with 2 digits to the right of the decimal point. Use CAST to return the second column as a varchar. Use the CONVERT function to return the third column as the same data type as the first column. Use CONVERT to return the fourth column as a varchar, using style 1. 2. Write a SELECT statement that

Murach’s SQL for SQL Server – Exercise 5 – Guaranteed 100% score 1. Write a SELECT statement that returns two columns from the Invoices table: VendorID and PaymentSum, where PaymentSum is the sum of the PaymentTotal column. Group the result set by VendorID. 2. Write a SELECT statement that returns two columns: VendorName and PaymentSum, where PaymentSum is the sum of the PaymentTotal column. Group the result set by VendorName. Return only 10 rows, corresponding to the 10 vendors who’ve been paid the most. Hint: Use the TOP clause and join Vendors to Invoices. 3. Write a SELECT statement that