3- Write a query to display the customer code, balance, and total purchases for each customer. Total purchase is calculated by summing the line subtotals (as in question 2) for each customer. Sort the results by customer code, and use aliases as shown below. CUS CODE CUS BALANCE| Tetal Purchases 444 00 153 05 422.77 34.97 TO 44 10011 10012 10014 600 345 86 O 00 10015 .00 10018 216 55 4- Modify the query in (question 3) to include the number of individual product purchases made by each customer. (In other words, if the customer's invoice is based on three products, one per LINE_NUMBER, you count three product purchases. Note that in the original invoice data, customer 10011 generated three invoices, which contained a total of six lines, each representing a product purchase.) The output values must match those shown in Figure below, sorted by customer code. CUS CODE CUS BALANCE Total Purchases | Number of Puurchasen 00 345 86 000 10011 10012 10014 10015 10018 444 00 163 85 422 77 3497 70 44 000 216 56 5- Use a query to compute the total of all purchases, the number of purchases, and the average purchase amount made by each customer. The output values must match those shown in Figure below. Sort the results by customer code. CUS CODE CUS BALANCE Total Purchases Number of Purchases Average Purchase Amount 74.00 51.28 70 46 17.48 10011 0.00 444.00 10012 345.86 153.85 10014 D.00 422.77 10015 0.00 216.55 34.97 2 10018 70.44 70.44

Q: 7- Write a query to produce the number of invoices and the total purchase amounts by customer, using…

A: Hey, since multiple questions posted, we will answer first question according to our policy. If you…

Q: Using the code below, write a query to display the movie title, movie year, and movie genre for all…

A: Algorithm:Execute the CREATE TABLE SQL command to create a table named MOVIE with columns movie_id,…

Q: Given the table customers which contains columns customer_id, first_name, last_name, and state, and…

A: SELECT C.LASTNAME, A.STATE, A.ZIP FROM CUSTOMER AS C INNER JOIN ADDRESS AS A on…

Q: Write a query to display the author ID, first and last name for all authors who have never written a…

A: The below query will return the author ID, first name, and last name for all authors who have never…

Q: Write the T-SQL scripts for the following tasks:   Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Write a query to display the author ID, first name, last name, and year of birth for all authors.…

A: A database may be defined in one of these ways it's an organized series of established facts or…

Q: using the code belowe write a query to display the movie genre and average price rental fee for…

A: In the database analysis, understanding the distribution of movie costs across genres is a crucial…

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: Add a Calculated Field to a Totals Query In the first blank column, add a new column named Time on…

A: MS Access:- MS Access is an information and data management tool that is used to manage database and…

Q: Write a query using mysql to display grant title, summary and grand amount which was received during…

A: MySQL query to display grant title, summary and grand amount which was received during the past…

Q: Write a query to display the current salary for each employee in department 300. Assume that only…

A: In a corporate setting, managing employee information, salary details, and departmental affiliations…

Q: using the code below write a query to display the movie title, movie year, and movie genre for all…

A: Algorithm: Retrieve and Sort Movie Information by Genre and Year1. Create a MOVIE table with…

Q: Q1) Please write. a query statement from emp table to display deptno 10’s empno, ename, sal, and a…

A: --> As new_sale is increased 15% that means it increases by 115 out of 100% which is 115/100 =…

Q: 1) Display the Name of the Product and the corresponding name of the supplier of that Product.…

A: Structured Query Language (SQL) allows use of JOIN operation to obtain information from two or more…

Q: ​Create a Query with all products information whose price is >20.

A: Lets see the solution.

Q: Write a query to display the current salary for each employee in department 300. Assume that only…

A: We must take into account the compensation history kept in the figure 48 table in order to get the…

Q: 3. Write a query that retrieves the following results (note the column names and order of results):

A: The required result needs to fetch below columns :   Pub_id -> from publisher table Publisher's…

Q: using the code below write a query to display the movie title, movie genre, price description, and…

A: Select Columns: Choose the columns to be displayed: MOVIE_TITLE, MOVIE_GENRE, PRICE_DESCRIPTION, and…

Q: using the code write a query to display the movie number, movie title, movie cost, and movie genre…

A: 1. Create a table named MOVIE:   - Define columns:     - MOVIE_NUM as INT (Primary Key)     -…

Q: Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: The query follows the syntax given below. SELECT column1, column2 FROM table1 WHERE condition ORDER…

Q: Write a query that will display all movies with a return date of March 1, 2018, March 5, 2018, March…

A: Sql query to display all the movies with a return date of March 1, 2018, March 5, 2018, March 15,…

Q: Write a query to display student Id who registered for the course 1001, 1005. If they registered for…

A: SQL program is an given below for the students :

Q: How do software quality attributes like maintainability and scalability influence cost estimations?

A: Software quality attributes are the requirements that focus on the behavior of a software…

Q: Write a query to display the movie year, movie title, and movie cost sorted by movie year in…

A: 1. Create a new database (if not exists).2. Use the newly created database.3. Create RENTAL table…

Q: Employee ID 001 001 002 002 002 002 003 003 Year 2018 2019 2017 2018 2019 2020 |Salary 50000 55000…

A: Introduction: SQL (Structured Query Language) is a programming language that is used to conduct…

Q: Use the code below to write a query to display the movie title, movie year, and movie genre for all…

A: SQL (Structured Query Language) is a standard programming language for managing and manipulating…

Q: CUS_CODE 10011 10012 10014 10015 CUS_BALANCE 0.00 345.86 0.00 0.00 Total Purchases 444.00 153.85…

A: The solution is an given below :

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.  

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.