Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
4. Get a count of the records in InvoiceArchive, the column header should read Record Count. 5. Use the Vendors table, get the Vendor Name, Vendor Contact Last Name, and Vendor State. Sort the state in alphabetical order with the following column headers Vendor, Contact and State. 6. Create a query of your own that incorporates at least three concepts from the slides. 7. Get a list of where the account number is 553 and Invoice Line Item Description contains Address Correction. (Use table InvoiceLineItems) 8. SELECT Count(*) FROM Invoices where InvoiceDueDate between '01/31/2019' and '07/15/2020' 9. Get a list of unique Vendor IDs from the Invoices table.

4. Get a count of the records in InvoiceArchive, the column header should read Record Count. 5. Use the Vendors table, get the Vendor Name, Vendor Contact Last Name, and Vendor State. Sort the state in alphabetical order with the following column headers Vendor, Contact and State. 6. Create a query of your own that incorporates at least three concepts from the slides. 7. Get a list of where the account number is 553 and Invoice Line Item Description contains Address Correction. (Use table InvoiceLineItems) 8. SELECT Count(*) FROM Invoices where InvoiceDueDate between '01/31/2019' and '07/15/2020' 9. Get a list of unique Vendor IDs from the Invoices table.

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter3: Table Creation And Management
Section: Chapter Questions
Problem 3HOA: Add two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment...
See similar textbooks
icon
Related questions
Question
Murach’s SQL server 2019 for developers
4. Get a count of the records in InvoiceArchive, the column header should read Record Count. 5. Use the Vendors table, get the Vendor Name, Vendor Contact Last Name, and Vendor State. Sort the state in alphabetical order with the following column headers Vendor, Contact and State. 6. Create a query of your own that incorporates at least three concepts from the slides. 7. Get a list of where the account number is 553 and Invoice Line Item Description contains Address Correction. (Use table InvoiceLineItems) 8. SELECT Count(*) FROM Invoices where InvoiceDueDate between '01/31/2019' and '07/15/2020' 9. Get a list of unique Vendor IDs from the Invoices table.
Transcribed Image Text:4. Get a count of the records in InvoiceArchive, the column header should read Record Count. 5. Use the Vendors table, get the Vendor Name, Vendor Contact Last Name, and Vendor State. Sort the state in alphabetical order with the following column headers Vendor, Contact and State. 6. Create a query of your own that incorporates at least three concepts from the slides. 7. Get a list of where the account number is 553 and Invoice Line Item Description contains Address Correction. (Use table InvoiceLineItems) 8. SELECT Count(*) FROM Invoices where InvoiceDueDate between '01/31/2019' and '07/15/2020' 9. Get a list of unique Vendor IDs from the Invoices table.
Expert Solution
Step 1

1. To get the count of the records in InvoiceArchive, use the following SQL query:

SELECT COUNT(*) AS [Record Count] FROM InvoiceArchive;

 

This will return a single row with a single column named "Record Count" that contains the number of records in the InvoiceArchive table.

 

 

2. To get the Vendor Name, Vendor Contact Last Name, and Vendor State from the Vendors table, sorted by state in alphabetical order, use the following SQL query:

SELECT VendorName AS Vendor, VendorContactLastName AS Contact, VendorState AS State
FROM Vendors
ORDER BY VendorState;

This will return a table with three columns named "Vendor", "Contact", and "State", sorted by the "State" column in ascending order.

 

 

 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
SQL Query
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
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
SEE MORE TEXTBOOKS