Provide a summary of customer balance characteristics for customers who made purchases. Include the minimum balance, maximum balance, and average balance, as shown in Figure P7.21. SELECT MIN(CUSTOMER.CUS_BALANCE) AS 'Minimum Balance', MAX(CUSTOMER.CUS_BALANCE) AS 'Maximum Balance', ROUND(AVG(CUSTOMER.CUS_BALANCE),2) AS 'Average Balance' FROM CUSTOMER WHERE CUS_CODE IN(SELECT CUS_CODE FROM INVOICE);    This does not work, what am i missing it is suppose to be    Minimum Balance 0.00 Maximum Balance 345.86 Average Balance 70.30

Q: The query that displays names of employees , sex , and evaluation of the salary for each department…

A: SELECT AVG(salary) /*incorrect*/ FROM EMPLOYEE, DEPENDENT  /* a salary is included once */ WHERE…

Q: An organization has committed to matching pledge amounts based on the donor type and pledge amount.…

A: The PL/SQL is in the next step-

Q: Write the SQL command for following i) Teams ( Teamcode , Teamname, Clubname, total_member,…

A: SQL Query: ⦁ In the table Teams-   ⦁ In Players table-   ⦁ In Tournament table-   ⦁ In…

Q: Based on the stage 2, write queries for the following questions: Sample output are provided for some…

A: As per our guidelines we are supposed to answer only one question. Kindly repost other questions as…

Q: What is the SQL command to list the number of product sales (number of rows) and total sales by…

A: SELECT TM_MONTH, P_CATEGORY, COUNT(*) AS NUMPROD, SUM(SALE_UNITS*SALE_PRICE) AS TOTSALES   FROM…

Q: the SQL code that will create the table structure for table: PRODUCT. Note: P_CODE is the Primary…

A: SQL Code: a) Create PRODUCT table BEGIN TRANSACTION; /* Create a table called JOBS */ CREATE TABLE…

Q: 4. Display customer ID, customer name, and the order ID and the order date of all orders for…

A: 4) SELECT c.CUSTOMER_ID, c.NAME, o.ORDER_ID, o.ORDER_DATE, oi.QUANTITY AS "Total Items",…

Q: 3. How many syntax errors in the following code? * proc sql; select count(Supplier_Name) 'Low Volume…

A: There were 4 syntax errors in the code given in the question. They are rectified using bold. The…

Q: 13. Using a single command sequence with the EMP_2 table, write the SQL code that will change the…

A: 13. The required SQL code to assign the value 18 to PROJ_NUM where JOB_CODE is 500 is given as…

Q: SQL to compute and display for each Product the Total Orders by Value, Number of Orders and Average…

A: It is defined as a database computer language designed for the retrieval and management of data in a…

Q: 8- Write a query to generate the total number of invoices, the invoice total for all of the…

A: SQL is a language to operate databases in searching and filtering the data according to the query

Q: IN SQL ** 1- Write a query clause to display the internal structure of the departments table, then…

A: As per our guidelines, we are supposed to answer only one question. Kindly repost the remaining…

Q: Need assistance with SQL assignment question: Populate the CUST_NUM, INV_DATE, and INV_AMOUNT…

A: To insert data into table, there must be a table So, first of all create a table and then execute…

Q: 1- Find ( display or select) the employees who have salary greater than the salary of all employees…

A: The answer for the given question is as follows.

Q: Generate a listing of all purchases made by the customers, using the output shown in the following…

A: SQL query The SQL code for sorting the results by invoice number, product description and customer…

Q: Display CustomerName and Status as 'Q2 for every customer who was born during the 2nd quarter of…

A: The given problem is related to database SQL query. The problem has provided the msCustomer table…

Q: Your manager requires you to create an SQL query that will display the combined customer name, the…

A: SQL query to select customer name ,townhouse number ,material and purchase amount ,in which purchase…

Q: Create the INVOICE table structure illustrated in Figure P8.16. INV_NUM should store integer values.…

A: Since database is not mentioned I am assuming Oracle database.

Q: Company also likes to find out the total purchase amount and the number of transactions made by each…

A: Please find the answer in step 2.

Q: Write a query to display all vendors sorted by vendor name. Write a query to display the product id,…

A: As per our company guidelines we are not supposed to answer more than 3 subparts of question and…

Q: Create SQL queries to calculate the average ranking (AVG), the total of the rankings (SUM), and the…

A: Sql query to count the number of ratings using COUNT: SELECT COUNT(column_name) FROM table_name;…

Q: Based on table below, using oracle: used subqueries, display the name of supplier(s) that supplied…

A: MAX will fetch the maximum value in column

Q: They need all the service requests with the category of Plumbing (category number 1) and Heating…

A: The given requirement is to be solved in the form of SQL command where the only service requests are…

Q: Import the ticket transaction data set and what teams (besides Washington Capitals) and what seat…

A: Answer: This type of question from machine learning so we will discuss in brief.

Q: write the SQL code that will yield the total number of hours worked for each employee and the total…

A: SELECT A. EMP_NUM, E.EMP_LNAME, ROUND (SUM(A. ASSIGN_HOURS),1) AS SumOfAssign_Hours , ROUND (SUM(A.…

Q: Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the…

A: query that will is: select e.last_name from employees e, employees m where e.manager_id =…

Q: Use the following table to answer the questions below: Table name: Customers Column Name Role Data…

A: As per our guidelines, we are supposed to answer only 1st 3 parts. Kindly repost the remaining…

Q: Write the SQL query to display the cid of all employees.  Write the SQL code to list all…

A: According to company rules we are only supposed to answer 3 subparts kindly upload the other…

Q: Based on table below, using oracle. used subqueries,display the name of supplier's that supplied…

A: Check for the supplier id's who supplied whose value is more than that of IBM computers  Then, you…

Q: Create a stored procedure called sp_shipping_date where the billing date is equal to the order date…

A: Given   create procedure sp_shipping_date (@billing_date datetime) as select Orders.OrderID,…

Q: I. Which normal form is the following table in? I. Transfer the table to 3rd Normalised form and…

A: Primary key is (agreementID, BuildingID) The FDs are AgreementID -> Duration UnitID ->…

Q: Task 19: List the REP_ID and the corresponding sum of the balances, as BALANCE, of all customers for…

A: List the REP_ID and the corresponding sum of the balances, as BALANCE, of all customers for each…

Q: The InstantRide User Satisfaction team requires the average and maximum number of rides users have…

A: SELECT            USER_ID, COUNT(TRAVEL_ID) AS CNTFROM            TRAVELSGROUP BY…

Q: the employee table have the following . ask user what is the employee_id and how much employee…

A:

Q: Write SQL code to ensure that the BOOKING_STATUS will only allow the words confirmed, tentative,…

A: Write SQL Code to ensure that the Booking_status will only allow the words…

Q: Use the following table to answer the questions below: Table name: Customers Column Name Role Data…

A: Create a table Customers with the below query: create table Customers(customerID char(5) PRIMARY…

Q: PLZ HELP WITH THE FOLLOWING: make the following work select MOVIE_NAME, MOVIE_YEAR from MOVIE…

A: Given,    List movie title and movie year for movies that have a movie cost is greater than…

Q: You want to use the summarize() and max() functions to find the maximum rating for your data. Add…

A: Note: As you had not provided any information about any particular data set . we have provide a…

Q: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the…

A: DELIMITER// CREATE PROCEDURE VATCalculator() BEGIN SELECT…

Q: Write the SQL code that will produce the results shown as below. Write the SQL code to calculate the…

A: SELECT             PROJ_NAME, PROJ_VALUE, PROJ_BALANCE, EMPLOYEE.EMP_LNAME,…

Q: 8. Which of the following SELECT statements displays a list of student names from the Students…

A: explanation: in the given option only statement B will include both 2020001 and 2020100

Q: lease use the picture to answer the following question Normalize below user view to the third…

A: The given samples in question are Team details which include the number and name of the team along…

Q: 14. Show the empno, name, hiring date and designation of those employees whose hiredate falls…

A: date 1 and date 2 are read and stored in a variable and used in  the query please use relevant…

Q: Please write a query statement from emp table to display employee's empno, ename, length of ename,…

A: Given that Please write a query statement from emp table to display employee's empno, ename, length…

Q: Q4-B: Write the required PHP statements to display all users orders in an HTML Table as follows:…

A: Please upvote please please. I am providing you the correct answer. I need it badly please.…

Q: When you don’t know the specific value to include in the criteria, you use a ____. a.…

A: Explanation: Parameter query is a type of query, one can update the information easily. It prompts…

Q: 18. The HR department needs a report of employees in Toronto. Display the last ame, job, de ment…

A: We are supposed to solve only question, please repost other question.   The query is written for…

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.