Skip to main content

Resources under Main Menu in Interact 2 go to Assignment 5 Folder

Task
Instructions
From Resources under Main Menu in Interact 2 go to Assignment 5 Folder
The ‘assignments’ database file will be made available on Interact2 Resources under Assessments folder.
Use MySQL software to complete this assignment.
Follow the instructions on ‘how to import a database into MySQL.: your teacher will also demonstrate this during class.
Use this (imported) database ‘assignment5 to complete your assignment using MySQL.
A choice of another software may be possible after consultation with your teacher.
Write SQL statements to answer the following questions from the ‘assignment5’ database file.
1. Show sums of line totals for each invoice.
2. Locate the record in the vendor table that does not have a value for the attribute V_STATE
3. Find the customers whose balance is greater than 200 but less than 300.
4. Using natural join and having. list the customers whose invoice total is greater than 200
5. Show the names of the customers for whom we have invoices.
6. Using natural join and having. list the customers whose invoice total is greater than the average
7. Show the names of the customers for whom we DO NOT have invoices.
8. Using natural join and having. list the customers whose invoice total is the maximum.
9. List the first name and last name of the customers and how many times a customer has generated an invoice.
10. List all purchases by customer 10018.
11. List the names of the vendors who provided products.
12. Using inner join. list the details of the products which sold more than 10 units.
You are required to submit:
1. The SQL statements for each query. which should be copied from your MySQL Workbench and pasted into your submission file. The screenshots of the results of the SQL statements which are to be copied from your MySQL Workbench and pasted into your submission file immediately after you execute the SQL query.
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.



CLICK HERE TO ORDER THIS PAPER………………………NO PLAGIARISM Get 100% Original papers from the writing expertsLogo CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS……

Comments

Post a Comment

Popular posts from this blog

Netanel (1996) talks about the NIEP theory approach to copyright and the democratic paradigm. Explain the difference between these in your own words. Lessig (2008) talks about read-only (RO) and read/write (RW) culture. How can copyright facilitate both of these?

chapter one Introduction A ‘‘Largely Ignored Paradox’’ The u.s. supreme court has famously labeled copyright ‘‘the engine of free expression.’’1 Copyright law, the Court tells us, provides a vital economic incentive for the creation and distribution of much of the literature, commentary, music, art, and film that makes up our public discourse. Yet copyright also burdens speech. We often copy or build upon another’s words, images, or music to convey our own ideas effectively. We cannot do that if a copyright holder withholds permission or insists upon a license fee that is beyond our means. And copyright does not extend merely to literal copying. It can also prevent parodying, remolding, critically dissecting, or incorporating portions of existing expression into a new, independently created work. Consider The Wind Done Gone, a recent, best-selling novel by African American writer Alice Randall. Randall’s novel revisits the setting and characters of Margaret Mitchell’s classic Civil War
Post a Comment
Read more

Explain why HAMILTON is considered “a cultural monument?”

  Module 7: Theatre Now: Steps Toward Diversity Chapter Questions Read Chapter 9 “Musicals of the Twenty-First Century” (pages 244 to 246) and Chapter 10 (pages 247 to 260) in your textbook. Choose only 5 of these questions to answer. Write your answers in your own words; if you choose to quote from the textbook, remember to identify the source. Question # Chapter Questions 1 9 Explain how Broadway musicals have changed in the 21st century. 2 9 Explain why HAMILTON is considered “a cultural monument?” 3 10 Identify the current focus/topics of the American theatre’s social awareness. 4 10 Give an example of how current theatre is addressing inequality in each of these areas: (a) gender and sexuality (b) racism (c) access to theatre for people with disabilities 5 10 How has theatre moved from its pre-1960s attitude that plays must not be open about the Love that dare not speak its name? [This expression was first used by Lord Alfred Douglas in his 1894 poem, “Two Loves” written in refere
Post a Comment
Read more

CBS Undercover Boss website

  Go to the CBS   Undercover Boss   website and search for a full episode of the show. Imagine you are the CEO of the company in the selected episode.  please do this with 2 pages Provide a detailed comparison of two job positions from the episode. Perform a job analysis of each position. Provide a clear, detailed description of your method of collecting the information for the job analysis. Examples include one-on-one, interview, or survey. Create a detailed job description from the two positions you analyzed. Provide clear, conclusive rationale for why the job analyses and job descriptions comply with state and federal regulations. Support your propositions, assertions, arguments, or conclusions with at least three credible, relevant, and appropriate sources synthesized in a coherent analysis. Cite each source on your source list at least once within your assignment. For help with research, writing, and citation, access the  library  or review  library guides . Write clearly and conc
Post a Comment
Read more