Show sums of line units for each invoice using sql query

Assignment Help Database Management System

Reference no: EM132376017

Assessment- Query databases using SQL

Write and run SQL statements to complete the following tasks

1. Show sums of line units for each invoice.

2. Show the details of the products that do not have a value for the attribute v_code.

3. Show the details of the invoices whose subtotal is greater than 24 but less than 76.

4. Show the details of the invoice who has the minimum subtotal.

5. Show the codes and names of the vendors who supplied products.

6. Using EXCEPT show the codes of the vendors who did not supply any products.

7. Using ‘NOT IN’ show the codes and names of the vendors who did not supply any products.

8. List the names and codes of vendors and the number of products each vendor has supplied, i.e. vendor XXX has supplied xxx products, and vendor YYY has supplied yyy products etc.

9. Show the details of the employees who are located in area code 615.

10. Using inner join, list the details of the products whose line price is greater than 99.

Attachment:- SQL Assignment.rar

Reference no: EM132376017

Questions Cloud

How does he attempt to persuade and convince his audience : Frederick Douglass wrote his narrative to advance the abolitionist cause. The account of his life was meant to serve as a powerful argument against.

What motivates your team or what inspires your team : Is it more important to decipher what motivates your team or what inspires your team? How are the two different?

Explain why confidentiality is important in your role : Explain why confidentiality is important in your role as a health care professional or manager?

Define why the attack was successful : Find an article on the Internet outline a security breach or cyber-attack. Provide a link to the article, what type of attack was used, why the attack.

Show sums of line units for each invoice using sql query : Show the codes and names of the vendors who supplied products. Using EXCEPT show the codes of the vendors who did not supply any products.

Discuss varying perspectives and approaches : For this assignment, you'll compile a list of sources that discuss varying perspectives and approaches to the social, political, or ethical problem you choose.

Compare and contrast qualitative data vs quantitative data : Compare and contrast qualitative data vs quantitative data. Your research paper should be at least 3 pages (800 words), double-spaced, have at least 4 APA.

Identify the countermeasures that need to be implemented : In this scenario, hackers launch cyber attacks that affect several parts of the nation's financial infrastructure over the course of several weeks.

How implementing diversity and commonality could help : Create a new thread. As indicated above, discuss how the types of threats discussed in the article referenced above could impact our economy.

User Account

All Pages