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

Using php and sql: create a query that will output only the user_id and message for user_id 8
Can you help mewith these SQL queries. I have attached the questions below
in SQL Code: Explain the difference between number and binary integer and how it is used? Please provide a code example
Answer the following SQL questions using MySQL command language in MySQL Workbench, sakila database environment!
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
Can you help me with this SQL tutorial? I have attached the question below.
Is SQL coding?
Contrast the term SQL; XQuery?
How does SQL Server Integration Services function internally?
Create a simple bank payment system table using Microsoft SQL Server Management Studio 18 and you could DELETE,UPDATE and EDIT all entries