SQL serveranswer question 4 and 5 Exercises1. Write a SELECT statement that returns two columns based on the Vendorstable. The first column, Contact, is the vendor contact name in this format:first name followed by last initial (for example, "John S.") The secondcolumn, Phone, is the VendorPhone column without the area code. Onlyreturn rows for those vendors in the 559 area code. Sort the result set by firstname, then last name.2. Write a SELECT statement that returns the InvoiceNumber and balance duefor every invoice with a non-zero balance and an InvoiceDueDate that's lessthan 30 days from today.3. Modify the search expression for InvoiceDueDate from the solution forexercise 2. Rather than 30 days from today, return invoices due before the lastday of the current month.4. Write a summary query that uses the CUBE operator to return LineItemSum(which is the sum of InvoiceLineItemAmount) grouped by Account (an aliasfor AccountDescription) and State (an alias for VendorState). Use the CASEand GROUPING function to substitute the literal value **ALL*" for thesummary rows with null values.5. Add a column to the query described in exercise 2 that uses the RANK()function to return a column named BalanceRank that ranks the balance due indescending order.

“Since you have asked multiple questions, we will solve the first question for you. If you want any…

4. Write a summary query that uses the CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) grouped by Account (an alias for Account Description) and State (an alias for VendorState). Use the CASE and GROUPING function to substitute the literal value **ALL*" for the summary rows with null values.

4. Write a summary query that uses the CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) grouped by Account (an alias for Account Description) and State (an alias for VendorState). Use the CASE and GROUPING function to substitute the literal value **ALL*" for the summary rows with null values.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What is SQL injection?
What is the case when in SQL Server?
Do SQL Server Integration Services function as intended?
How exactly does SQL Server Integration Services function?
SQL query select with condition of multiple values from column?
How does SQL Server Integration Services operate on a more fundamental level?
Question: In the context of databases, what does the acronym SQL stand for? a) Structured Question Language b) Simple Query Language c) Standard Query Language d) Sequential Query Language
Return customers and their orders, including customers who placed no orders: Tables involved: Sales.Customers and Sales.Orders how do i do this in SQL Server
Is SQL coding?
How does SQL Server's Integration Services function internally?
Contrast the term SQL; XQuery?
How does SQL Server Integration Services function internally?