EXPLORER Piedmont Technical College D2L Lab 5-1: Kim Tay Pet Supplies (Ass X | MindTap - Cengage Learning Companion - student [Codespace X + ΑΠ https://opulent-cod-69vvqr75799xhrqwp.github.dev/?folder=/workspaces/9780357419748_a-guide-to-sql-9b87151b-b6ec-4283-af5b-cbe... ✓ STUDENT [CODESPACES: OPULENT COD] C* Kim Tay.dump.sql query.sql > OUTLINE > TIMELINE > Codespaces: opulent cod 00 1 Russell 1000 +1.32% ← student [Codespaces: opulent cod] query.sql 1 query.sql X SELECT I. INVOICE_NUM, I. INVOICE_DATE * Welcome 2 FROM INVOICES I 3 INNER JOIN CUSTOMER C Ev 4 ON I.CUST_ID = C.CUST_ID 5 INNER JOIN INVOICE_LINE L 6 ON I. INVOICE_NUM = L. INVOICE_NUM 7 INNER JOIN ITEM T 8 ON L.ITEM_ID = T.ITEM_ID Ev 9 WHERE T.DESCRIPTION = "Wild Bird Food (25lb)" 10 AND (C.FIRST_NAME = "James" AND C. LAST_NAME = "Gonzalez"); 11 12 13 14 15 16 17 18 19 20 2222 号 Companion X + ☐ 日 日 Task 18: List the item ID, des 4 Task 19: For each item, list th <> number and quantity ordered Task 20: Repeat Task 18 using Task 21: For each sales rep, li 08 0€ PROBLEMS OUTPUT DEBUG CONSOLE TERMINAL PORTS 1 Query Output Ex 8 ^ INVOICE_NUM H Q Search INVOICE_DATE Layout: US 11:01 AM 6/12/2024
EXPLORER Piedmont Technical College D2L Lab 5-1: Kim Tay Pet Supplies (Ass X | MindTap - Cengage Learning Companion - student [Codespace X + ΑΠ https://opulent-cod-69vvqr75799xhrqwp.github.dev/?folder=/workspaces/9780357419748_a-guide-to-sql-9b87151b-b6ec-4283-af5b-cbe... ✓ STUDENT [CODESPACES: OPULENT COD] C* Kim Tay.dump.sql query.sql > OUTLINE > TIMELINE > Codespaces: opulent cod 00 1 Russell 1000 +1.32% ← student [Codespaces: opulent cod] query.sql 1 query.sql X SELECT I. INVOICE_NUM, I. INVOICE_DATE * Welcome 2 FROM INVOICES I 3 INNER JOIN CUSTOMER C Ev 4 ON I.CUST_ID = C.CUST_ID 5 INNER JOIN INVOICE_LINE L 6 ON I. INVOICE_NUM = L. INVOICE_NUM 7 INNER JOIN ITEM T 8 ON L.ITEM_ID = T.ITEM_ID Ev 9 WHERE T.DESCRIPTION = "Wild Bird Food (25lb)" 10 AND (C.FIRST_NAME = "James" AND C. LAST_NAME = "Gonzalez"); 11 12 13 14 15 16 17 18 19 20 2222 号 Companion X + ☐ 日 日 Task 18: List the item ID, des 4 Task 19: For each item, list th <> number and quantity ordered Task 20: Repeat Task 18 using Task 21: For each sales rep, li 08 0€ PROBLEMS OUTPUT DEBUG CONSOLE TERMINAL PORTS 1 Query Output Ex 8 ^ INVOICE_NUM H Q Search INVOICE_DATE Layout: US 11:01 AM 6/12/2024
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...
Related questions
Question
![EXPLORER
Piedmont Technical College
D2L Lab 5-1: Kim Tay Pet Supplies (Ass X | MindTap - Cengage Learning
Companion - student [Codespace X +
ΑΠ
https://opulent-cod-69vvqr75799xhrqwp.github.dev/?folder=/workspaces/9780357419748_a-guide-to-sql-9b87151b-b6ec-4283-af5b-cbe...
✓ STUDENT [CODESPACES: OPULENT COD]
C*
Kim Tay.dump.sql
query.sql
> OUTLINE
> TIMELINE
> Codespaces: opulent cod 00 1
Russell 1000
+1.32%
←
student [Codespaces: opulent cod]
query.sql
1
query.sql X
SELECT I. INVOICE_NUM, I. INVOICE_DATE
* Welcome
2
FROM INVOICES I
3
INNER JOIN CUSTOMER C
Ev
4
ON I.CUST_ID = C.CUST_ID
5
INNER JOIN INVOICE_LINE L
6
ON I. INVOICE_NUM = L. INVOICE_NUM
7
INNER JOIN ITEM T
8
ON L.ITEM_ID = T.ITEM_ID
Ev
9
WHERE T.DESCRIPTION = "Wild Bird Food (25lb)"
10
AND (C.FIRST_NAME = "James" AND C. LAST_NAME
=
"Gonzalez");
11
12
13
14
15
16
17
18
19
20
2222
号
Companion X
+
☐
日
日
Task 18: List the item ID, des 4
Task 19: For each item, list th <>
number and quantity ordered
Task 20: Repeat Task 18 using
Task 21: For each sales rep, li
08
0€
PROBLEMS OUTPUT DEBUG CONSOLE TERMINAL PORTS 1
Query Output
Ex 8
^
INVOICE_NUM
H
Q Search
INVOICE_DATE
Layout: US
11:01 AM
6/12/2024](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe5fc5ad0-c601-4697-a1f6-eafe98234d48%2F64fcb14f-e02f-43aa-91c1-b8d8d35377d3%2Fv1zd8te_processed.png&w=3840&q=75)
Transcribed Image Text:EXPLORER
Piedmont Technical College
D2L Lab 5-1: Kim Tay Pet Supplies (Ass X | MindTap - Cengage Learning
Companion - student [Codespace X +
ΑΠ
https://opulent-cod-69vvqr75799xhrqwp.github.dev/?folder=/workspaces/9780357419748_a-guide-to-sql-9b87151b-b6ec-4283-af5b-cbe...
✓ STUDENT [CODESPACES: OPULENT COD]
C*
Kim Tay.dump.sql
query.sql
> OUTLINE
> TIMELINE
> Codespaces: opulent cod 00 1
Russell 1000
+1.32%
←
student [Codespaces: opulent cod]
query.sql
1
query.sql X
SELECT I. INVOICE_NUM, I. INVOICE_DATE
* Welcome
2
FROM INVOICES I
3
INNER JOIN CUSTOMER C
Ev
4
ON I.CUST_ID = C.CUST_ID
5
INNER JOIN INVOICE_LINE L
6
ON I. INVOICE_NUM = L. INVOICE_NUM
7
INNER JOIN ITEM T
8
ON L.ITEM_ID = T.ITEM_ID
Ev
9
WHERE T.DESCRIPTION = "Wild Bird Food (25lb)"
10
AND (C.FIRST_NAME = "James" AND C. LAST_NAME
=
"Gonzalez");
11
12
13
14
15
16
17
18
19
20
2222
号
Companion X
+
☐
日
日
Task 18: List the item ID, des 4
Task 19: For each item, list th <>
number and quantity ordered
Task 20: Repeat Task 18 using
Task 21: For each sales rep, li
08
0€
PROBLEMS OUTPUT DEBUG CONSOLE TERMINAL PORTS 1
Query Output
Ex 8
^
INVOICE_NUM
H
Q Search
INVOICE_DATE
Layout: US
11:01 AM
6/12/2024
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY