Task 15: List the invoice number and invoice date for each invoice that either was created for James Gonzalez or that contains an invoice line for Wild Bird Food (25lb). Task 16: List the invoice number and invoice date for each invoice that was created for James Gonzalez and that contains an invoice line for Wild Bird Food (25lb).

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Task 15: List the invoice number and invoice date for each invoice that either was created for James Gonzalez or that contains an invoice line for Wild Bird Food (25lb).

Task 16: List the invoice number and invoice date for each invoice that was created for James Gonzalez and that contains an invoice line for Wild Bird Food (25lb).

# Educational Website Content:

## Invoices Table:
### Overview:
The "Invoices Table" provides details about various invoices generated, including invoice numbers, dates, and associated customer IDs.

| **INVOICE_NUM** | **INVOICE_DATE** | **CUST_ID** |
|-----------------|------------------|-------------|
| 14216           | 2021-11-15       | 125         |
| 14219           | 2021-11-15       | 227         |
| 14222           | 2021-11-16       | 294         |
| 14224           | 2021-11-16       | 182         |
| 14228           | 2021-11-18       | 435         |
| 14231           | 2021-11-18       | 125         |
| 14233           | 2021-11-18       | 435         |
| 14237           | 2021-11-19       | 616         |

---

## Customer Table:
### Overview:
The "Customer Table" provides information about customers, including their IDs, contact information, account balances, and credit limits.

| **CUST_ID** | **FIRST_NAME** | **LAST_NAME** | **ADDRESS**     | **CITY**   | **STATE** | **POSTAL** | **EMAIL**               | **BALANCE** | **CREDIT_LIMIT** | **REP_ID** |
|-------------|----------------|---------------|-----------------|------------|-----------|------------|------------------------|-------------|------------------|------------|
| 125         | Joey           | Smith         | 17 Fourth St    | Cody       | WY        | 82414      | jsmith17@example.com   | 80.68       | 500.00           | 05         |
| 182         | Billy          | Rufton        | 21 Simple Cir   | Garland    | WY        | 82435      | billyruff@example.com  | 43.13       | 750.00           | 10         |
| 227         | Sandra         | Pincher       | 53 Verde Ln     | Powell     | WY        | 82440      | spinch2@example.com    | 156.38      | 500.00           | 15         |
| 294         | Samantha       | Smith         | 14 Rock Ln
Transcribed Image Text:# Educational Website Content: ## Invoices Table: ### Overview: The "Invoices Table" provides details about various invoices generated, including invoice numbers, dates, and associated customer IDs. | **INVOICE_NUM** | **INVOICE_DATE** | **CUST_ID** | |-----------------|------------------|-------------| | 14216 | 2021-11-15 | 125 | | 14219 | 2021-11-15 | 227 | | 14222 | 2021-11-16 | 294 | | 14224 | 2021-11-16 | 182 | | 14228 | 2021-11-18 | 435 | | 14231 | 2021-11-18 | 125 | | 14233 | 2021-11-18 | 435 | | 14237 | 2021-11-19 | 616 | --- ## Customer Table: ### Overview: The "Customer Table" provides information about customers, including their IDs, contact information, account balances, and credit limits. | **CUST_ID** | **FIRST_NAME** | **LAST_NAME** | **ADDRESS** | **CITY** | **STATE** | **POSTAL** | **EMAIL** | **BALANCE** | **CREDIT_LIMIT** | **REP_ID** | |-------------|----------------|---------------|-----------------|------------|-----------|------------|------------------------|-------------|------------------|------------| | 125 | Joey | Smith | 17 Fourth St | Cody | WY | 82414 | jsmith17@example.com | 80.68 | 500.00 | 05 | | 182 | Billy | Rufton | 21 Simple Cir | Garland | WY | 82435 | billyruff@example.com | 43.13 | 750.00 | 10 | | 227 | Sandra | Pincher | 53 Verde Ln | Powell | WY | 82440 | spinch2@example.com | 156.38 | 500.00 | 15 | | 294 | Samantha | Smith | 14 Rock Ln
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY