Instructions Using the data provided in the Ch13_SaleCo; database, solve the following problems. (Hint: In Problems 5–11, use the ROLLUP command.) Below is the Schema for the database: Problem 7 What is the SQL command to list the total sales by region and customer, with subtotals by region and a grand total for all sales? Figure P13.7 shows the result of the query.

Using the relations in the appendix, write the following queries in SQL:i. Display a list of all instructors, showing each instructor’s ID and the number of sections taught. Your query should use an outer join, and should not use sub-queries.ii. Write the same query as in part a, but using a scalar subquery and not using outer join.iii. Display the list of all course sections offered in spring 2018, along with the ID and name of each instructor teaching the section. If a section has more than one instructor, that section should appear as many times in the result as it has instructors. If a section does not have any instructor, it should still appear in the result with the instructor name set to “—”.iv. Display the list of all departments, with the total number of instructors in each department, without using sub-queries. Make sure to show departments that have no instructors, and list those departments with an instructor count of zero.

How do you ensure that user-defined functions in SQL maintain data consistency?

A pipe allows you to... ...send the same input to multiple commands. ...type multiple commands at one prompt. ...send the output of a command to a file. ...send the output of one command to another.

please use SQL to answer the following question an erd had been provide as well

database

What is the need for transactions in SQL?

These are queries that use the full Red Cat Database as shown in Figure 3.1.  To do these queries you cannot use the SimplifiedSales database.  You must use the full Red Cat tables of Customer, Sale, SaleItem, Product, Manufacturer, and Employee tables. For each information request below, formulate a single SQL query to produce the required information.  In each case, you should display only the columns requested.  Be sure that your queries do not produce duplicate records unless otherwise directed. List the information in the SaleItem table concerning green sneakers. Use the first letter of each table name as alias names. (Note: Colors are capitalized while categories are not. ) Note: Your answer should dynamically include all current columns in the saleItem table  and any future changes to columns.

Use the Pine Valley Furniture (PVF) database for this question. Write a SQL query to display the customer ID and total number of orders placed for those customers who placed more than one order.

use sql to answer the following question To perform below tasks, refer to tables in the JustLee Book database. Create a list that display the title of each book and the name and phone number of the contact at the publisher’s office for reordering each book. Which books were written by an author with the Last Name-First Name (BAKER JACK)? Perform the search using author’s last name/first name. Determine which book(s) purchased by customer Steve Schell. Perform the search using the customer name & last name, not the customer number. If he/she has purchased multiple copies of the same book, unduplicated(DISCTINC) the result.