Write and run SQL statements to show sums of line units

Assignment Help Database Management System

Reference no: EM132380761

Assignment - 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 tine price is greater than 99.

You are required to submit:

1. The SQL statements for each query, which should be copied from your SQLite3 Command Line and pasted into your submission file. If you type .echo on at the SQLite3 Command Line, SQLite will output your SQL statement with the results of the query making it easy to copy and paste both.

2. The screenshots of the results of the SQL statements which are to be copied from your SQLite3 Command Line and pasted into your submission file immediately after you execute the SQL query. If you used an output file please submit only the output file.

Reference no: EM132380761

Questions Cloud

Create journal entries to record the transactions : One month's insurance coverage has expired. The company occupied the office space for the month of December. At the end of the month.

How do you give feedback during a conversation : How do you give feedback during a conversation? Do you provide it face to face or some other way?

What communication strategies would you use to communicate : What communication strategies would you use to communicate with an upset client at this point. The response paper should be in APA format.

Evaluate why some companies get to the top of indusry : Evaluate why some companies get to the top of indusry rankings and stay there while others do not. Use details and examples to support your answer.

Write and run SQL statements to show sums of line units : Write and run SQL statements to complete the following tasks - Show sums of line units for each invoice. Show the codes and names of the vendors

Marketing strategy and consumer behavior : Marketing Strategy & Consumer Behavior-What changes are faced by corporations in reducing the barriers to a healthy diet faced by those consumers of lower SES?

Prepare the adjusted bank balance section : Prepare the adjusted bank balance section and the adjusted book balance section of the bank reconciliation statement. Prepare the necessary journal entries.

Why did the company subsequently stumble in north america : What lessons did IKEA learn from this experience? How is the company now applying these lessons? (300 wrds or more)

First group of indigenous employees : You have employed the first group of indigenous employees some of whom will be working in the sales department and others in customer care.

User Account

All Pages