Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW. 1 Task 11: List all the columns contained within the system catalog, but only display the first 11 records that are in the KimTay TABLE_SCHEMA. 1 Task 12: List all the views contained within the system catalog, but only display the first 12 records.
Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW. 1 Task 11: List all the columns contained within the system catalog, but only display the first 11 records that are in the KimTay TABLE_SCHEMA. 1 Task 12: List all the views contained within the system catalog, but only display the first 12 records.
Chapter8: Working With Advanced Functions
Section8.2: Lookup Tables And The Iferror Function
Problem 4QC
Related questions
Question
Please take note of the Limit clause and answer questions. i included a screenshot of all tables.
Use the LIMIT clause to select a limited number of records to display.
Tasks
Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW.
1
Task 11: List all the columns contained within the system catalog, but only display the first 11 records that are in the KimTay TABLE_SCHEMA.
1
Task 12: List all the views contained within the system catalog, but only display the first 12 records.
![The CUSTOMER table maintains information about each customer, such as their ID, first and last
name, address, balance, and credit limit.
CUST_ID FIRST_NAME LAST_NAME
125
182
227
294
314
375
435
492
543
616
721
795
Joey
Billy
Sandra
Samantha
Tom
Melanie
James
Elmer
Angie
Sally
Leslie
Randy
CUSTOMER table
Smith
Rufton
Pincher
Smith
Rascal
Jackson
Gonzalez
Jackson
Hendricks
Cruz
Smith
Blacksmith
ADDRESS
17 Fourth St
21 Simple Cir
53 Verde Ln
14 Rock Ln
1 Rascal Farm Rd
42 Blackwater Way
16 Rockway Rd
22 Jackson Farm Rd
27 Locklear Ln
199 18th Ave
123 Sheepland Rd
75 Stream Rd
CITY
Cody
Garland
Powell
Ralston
Cody
Wapiti
Garland
Powell
Ralston
Elk Butte
STATE POSTAL
Elk Butte WY
Cody
WY
WY
WY
WY
WY
WY
WY
WY
WY
WY
WY
82414
82435
82440
82440
82414
82433
82450
82435
82440
82440
82433
82414
EMAIL
jsmith17@example.com
billyruff@example.com
spinch2@example.com
ssmith5@example.com
trascal3@example.com
mjackson5@example.com
jgonzo@example.com
ejackson4@example.com
ahendricks7@example.com
scruz5@example.com
Ismith12@example.com
rblacksmith6@example.com
BALANCE CREDIT_LIMIT REP_ID
80.68
43.13
156.38
58.60
17.25
252.25
230.40
45.20
315.00
8.33
166.65
61.50
500.00
750.00
500.00
500.00
250.00
250.00
1000.00
500.00
750.00
500.00
1000.00
500.00
05
10
15
10
15
05
15
10
05
15
10
05](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe6bd4225-180d-4082-8b34-5eeb1c99ecc7%2F6d6ac4a8-09b0-424b-973b-d9d39bc48837%2F4pu69g2_processed.png&w=3840&q=75)
Transcribed Image Text:The CUSTOMER table maintains information about each customer, such as their ID, first and last
name, address, balance, and credit limit.
CUST_ID FIRST_NAME LAST_NAME
125
182
227
294
314
375
435
492
543
616
721
795
Joey
Billy
Sandra
Samantha
Tom
Melanie
James
Elmer
Angie
Sally
Leslie
Randy
CUSTOMER table
Smith
Rufton
Pincher
Smith
Rascal
Jackson
Gonzalez
Jackson
Hendricks
Cruz
Smith
Blacksmith
ADDRESS
17 Fourth St
21 Simple Cir
53 Verde Ln
14 Rock Ln
1 Rascal Farm Rd
42 Blackwater Way
16 Rockway Rd
22 Jackson Farm Rd
27 Locklear Ln
199 18th Ave
123 Sheepland Rd
75 Stream Rd
CITY
Cody
Garland
Powell
Ralston
Cody
Wapiti
Garland
Powell
Ralston
Elk Butte
STATE POSTAL
Elk Butte WY
Cody
WY
WY
WY
WY
WY
WY
WY
WY
WY
WY
WY
82414
82435
82440
82440
82414
82433
82450
82435
82440
82440
82433
82414
EMAIL
jsmith17@example.com
billyruff@example.com
spinch2@example.com
ssmith5@example.com
trascal3@example.com
mjackson5@example.com
jgonzo@example.com
ejackson4@example.com
ahendricks7@example.com
scruz5@example.com
Ismith12@example.com
rblacksmith6@example.com
BALANCE CREDIT_LIMIT REP_ID
80.68
43.13
156.38
58.60
17.25
252.25
230.40
45.20
315.00
8.33
166.65
61.50
500.00
750.00
500.00
500.00
250.00
250.00
1000.00
500.00
750.00
500.00
1000.00
500.00
05
10
15
10
15
05
15
10
05
15
10
05
![In the INVOICES table contains information about each invoice, such as the invoice number,
date, and the customer being invoiced.
INVOICE_NUM
14216
14219
14222
14224
14228
14231
14233
14237
INVOICES table
INVOICE_DATE
2021-11-15
2021-11-15
2021-11-16
2021-11-16
2021-11-18
2021-11-18
2021-11-18
2021-11-19
CUST_ID
125
227
294
182
435
125
435
616](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe6bd4225-180d-4082-8b34-5eeb1c99ecc7%2F6d6ac4a8-09b0-424b-973b-d9d39bc48837%2F80bumtd_processed.png&w=3840&q=75)
Transcribed Image Text:In the INVOICES table contains information about each invoice, such as the invoice number,
date, and the customer being invoiced.
INVOICE_NUM
14216
14219
14222
14224
14228
14231
14233
14237
INVOICES table
INVOICE_DATE
2021-11-15
2021-11-15
2021-11-16
2021-11-16
2021-11-18
2021-11-18
2021-11-18
2021-11-19
CUST_ID
125
227
294
182
435
125
435
616
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning