Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2nd quarter of 2017 (April to June 2017). The image displays a relational database schema consisting of multiple interconnected tables. Each table represents a different entity within a business database system. Below is a description of each table and its associated fields:1. **Department Table** - **DEPT_NUM**: Numeric identifier for the department (Decimal 5,0). - **DEPT_NAME**: Name of the department (Varchar 50). - **DEPT_MAIL_BOX**: Department mailbox number (Varchar 3). - **DEPT_PHONE**: Department phone number (Varchar 9). - **EMP_NUM**: Employee number (Decimal 6,0).2. **Employee Table** - **EMP_NUM**: Unique number for each employee (Decimal 6,0). - **EMP_FNAME**: Employee's first name (Varchar 20). - **EMP_LNAME**: Employee's last name (Varchar 25). - **EMP_EMAIL**: Employee's email address (Varchar 25). - **EMP_PHONE**: Employee phone number (Varchar 20). - **EMP_HIREDATE**: Date of hire (Date). - **EMP_TITLE**: Job title (Varchar 45). - **EMP_COMM**: Commission rate (Decimal 2,2). - **DEPT_NUM**: Associated department number (Decimal 5,0).3. **Salary History Table** - **EMP_NUM**: Employee number (Decimal 6,0). - **SAL_FROM_DATE**: Start date of the salary period (Date). - **SAL_END_DATE**: End date of the salary period (Date). - **SAL_AMOUNT**: Salary amount (Decimal 10,2).4. **Invoice Table** - **INV_NUM**: Invoice number (Decimal 38,0). - **INV_DATE**: Date of the invoice (Date). - **CUST_CODE**: Customer code (Decimal 38,0). - **INV_TOTAL**: Total amount on the invoice (Decimal 11,2). - **EMPLOYEE_ID**: Employee responsible for the invoice (Decimal 6,0).5. **Customer Table** - **CUST_CODE**: Unique customer code (Decimal 38,0). - **CUST_FNAME**: Customer's first name (Varchar 20).

Overview : The COUNT() function returns the number of rows that matches a specified criterion. The…

Answered: Find out the total sales, minimum…

Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2nd quarter of 2017 (April to June 2017).

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

Related questions

Q: The query should list all employees whose Position begins with the word greenhouse and whose weekly…

A: These question answer is as follows,

Q: Task 4: Use the IN operator to find the ID, first name, and last name of each customer for which as…

A: The above question is solved in step 2 :-

Q: LIST THE FIRST AND LAST NAMES OF ALL OWNERS WHO OWN A TWO-BEDROOM PROPERTY. USE THE IN OPERATOR IN…

A: Considering there are 2 tables:- OWNER: which holds the OWNER_NUM, FIRST_NAME, and LAST_NAME…

Q: Using the Bowlers and Bowler_Scores tables, list the BowlerID, bowler name, and raw score for each…

A: The given problem requires us to find the BowlerID, bowler name, and raw score for each bowler who…

Q: Use SQL and TAL Distributors database to complete the following questions: List the item number and…

A: List the item number and description for all items. The descriptions should appear in uppercase…

Q: Insert into the LARGE_PROPERTY table the office number, address, bedrooms, floors, monthly rent, and…

A: We need to insert some columns from property table to largeproperty table whose square footage is…

Q: --List all products whose unit price is less than the average price. --List the shipper id,…

A: Given: consider the tables as. product { productID, productNAME, price_per_unit, category_product }…

Q: List all book titles that have never been borrowed by any borrower.

A: The SQL program for the given problem is as follows: use demo;Create table Book(ISBN varchar(30) Not…

Q: Write the SQL statement that shows the count of invoices, the highest invoice total, the lowest…

A: Since schema of the table is not mentioned, I am assuming that table has invoices column. The query…

Q: mysql> select * from item_db; | item_code | item_name 2 B 8 10 33 85 200 500 9 6 rows in set (0.00…

A: The number of orders made for the item with code '200' directly from the provided item_db table.…

Q: List the job title and maximum salary which the salaries are between $10,000 and $20,000. Use…

A: The objective of the question is to retrieve the job title and maximum salary from a database where…

Q: Question 6 (Must include subquery): Write, a query that returns every customer that has a loan at…

A: The query is given below with output screenshot Demo data has been used in tables

Q: t the title of all books in the same category as books previously purchased by customer 1007. Don’t…

A: Lets see the solution.

Q: How many distinct visit reasons start with the word "Pain"? Name the result column as NumPainReason.…

A: SELECT COUNT(DISTINCT VisitReason) AS NumPainReason FROM VisitWHERE VisitReason LIKE 'Pain%';

Q: Who has rented movies in Japanese language? Return only the first five distinct results in…

A: The INNER JOIN keyword chooses records from both tables whose values match. The SELECT clause just…

Q: Check the current stock to see what categories of books are available. Once per category only…

A: Because of this, we make use of the DISTINCT clause so that we may get rid of data set by getting…

Q: 1. Which customers live in New Jersey? List each customer’s last name, first name, and state.

A: The solution is given in next step: Let's say that the table's name is Customer for the moment.

Q: 4. Which customers live in Georgia or New Jersey? Put the results in ascending order by last name.…

A: Assume that, the name of the table is Customer The entities of Customer table are last name, first…

Q: Using the WHERE clause, filter the invoice table to find the invoices that were dated after March…

A: The question has been answered in step2

Q: 4. Determine which books customer Jake Lucas has purchased. Perform the search using the customer…

A: This question is from the subject database design and implementation. Using Sql we can solve this…

Q: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name,…

A: Hi there, Please find your solution below, I hope you would find my solution useful and helpful.…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Determine which orders had a higher total amount due than order 1008.

A: Explanation: The following query determines the orders where the total amount is higher than order…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition. student…

Q: Result : Honda Toyota 2 3 O Select Make, Count(Make) FROM Auto Group By Make; Select Make,…

A: COUNT() is an aggregate function that counts the number of rows returned by a query.The HAVING…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

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: Please explain how to set the mining “difficulty”.

A: The difficulties of mining association rules from large databases: 1. Security and social issues:…

Q: 2. Determine which orders haven’t yet shipped and the name of the customer who placed the order.…

A: According to the information given:- We have to follow the instruction in order to perform the…

Q: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below:

Q: For each order id, calculate the total of the Order. The total of an order is the sum of the prices…

A: For each order id, calculate the total of the Order. The total of an order is the sum of the prices…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: Queries are given below :

Q: Determine what kinds of books are currently in the library's collection. Each category should only…

A: Introduction: A vast array of books has always been housed in the libraries of colleges and…

Q: For every invoice, display the invoice number, invoice date and the total dollar amount for all…

A: Dear student your query get the error because inv_number exist in the two table so you have to…

Q: Mark as unused the Category column in the BOOK_PRICING table. Check that the column is no longer…

A: The BOOK_PRICING table is a part of a database used for managing pricing information for books. One…

Q: Determine which categories are covered by the existing book stock. There should only be one listing…

A: A trader's book contains a record of all of the positions that they have taken. The entire number of…

Q: Use SQL commands. Include both SQL commands and results in your answers. Include screenshots of the…

A: Join: A JOIN clause is used to combine rows from two or more tables, based on a related column…

Concept explainers

Basic SQL Queries

Structured Query Language is the full form of SQL. It is a high-level language used to communicate with a relational database. It is used for creating, storing and accessing contents of a relational database. SQL is used to write the queries which are executed using database engines like Oracle, SQL Server and so forth.

Question

Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2^nd quarter of 2017 (April to June 2017).

The image displays a relational database schema consisting of multiple interconnected tables. Each table represents a different entity within a business database system. Below is a description of each table and its associated fields:

1. **Department Table**
- **DEPT_NUM**: Numeric identifier for the department (Decimal 5,0).
- **DEPT_NAME**: Name of the department (Varchar 50).
- **DEPT_MAIL_BOX**: Department mailbox number (Varchar 3).
- **DEPT_PHONE**: Department phone number (Varchar 9).
- **EMP_NUM**: Employee number (Decimal 6,0).

2. **Employee Table**
- **EMP_NUM**: Unique number for each employee (Decimal 6,0).
- **EMP_FNAME**: Employee's first name (Varchar 20).
- **EMP_LNAME**: Employee's last name (Varchar 25).
- **EMP_EMAIL**: Employee's email address (Varchar 25).
- **EMP_PHONE**: Employee phone number (Varchar 20).
- **EMP_HIREDATE**: Date of hire (Date).
- **EMP_TITLE**: Job title (Varchar 45).
- **EMP_COMM**: Commission rate (Decimal 2,2).
- **DEPT_NUM**: Associated department number (Decimal 5,0).

3. **Salary History Table**
- **EMP_NUM**: Employee number (Decimal 6,0).
- **SAL_FROM_DATE**: Start date of the salary period (Date).
- **SAL_END_DATE**: End date of the salary period (Date).
- **SAL_AMOUNT**: Salary amount (Decimal 10,2).

4. **Invoice Table**
- **INV_NUM**: Invoice number (Decimal 38,0).
- **INV_DATE**: Date of the invoice (Date).
- **CUST_CODE**: Customer code (Decimal 38,0).
- **INV_TOTAL**: Total amount on the invoice (Decimal 11,2).
- **EMPLOYEE_ID**: Employee responsible for the invoice (Decimal 6,0).

5. **Customer Table**
- **CUST_CODE**: Unique customer code (Decimal 38,0).
- **CUST_FNAME**: Customer's first name (Varchar 20).

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Display Customer name (concatenate First Name and Last Name with a space between) and total number of orders for each customer. Name the total number of orders column as 'NumberOfOrders'. Sort based on Number of orders in descending order.
Please help with the following: Which column name is valid? Select one: a. NUMBER_1$ b. NUMBER c. 1_NUMBER# d. 1NUMBER
1. Report the student names and ages of all students who have a "hotmail" email address. Sort the results by age. 2. Report the number of male and female students.
Determine which types of books are currently available in the current inventory. Each category should only be included once.
7. What gift will a customer who orders the book Shortest Poems receive? Use the actualbook retail value to determine the gift.
For each customer, list the CustomerID and the total number of orders placed in 2015.
C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
1 rows returned in 0.00 seconds Download 7. In the OrderItems table, display the maximum item_price with the alias shown. 11.99 1 rows returned in 0.00 seconds Download Max Item Price
Query: List the IDs of the tutors who are currently tutoring more than one student
You will be using the Colonial Adventure Tours database. What is the average distance and average maximum group size for each type of trip?
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
Mark the Category field in the BOOK_PRICING table as not being used. Check to see if the field can still be used.