Business Finance Homework Help

Purpose: To provide you an opportunity to apply (SQL) in the data processing cycle.

Database: Northwind_original (on Canvas)

Tools: SQLiteStudio (See Instruction for Downloading SQLiteStudio on Canvas).

Before starting the assignment, install SQLiteStudio on your computer and download the above database in your computer.

To be submitted:

Submit each SQL assignment in ONE file. The file should include everything required to be submitted for that assignment.

• SQL query statements (21 statements)
• Screenshots of partial output for questions that require screenshots of output (total 4 screenshots, 8 points).

I also recommend copying and pasting your SQL statements into a word or notepad file and saving the file in multiple places (e.g., on a computer, email, cloud, external hard drive, etc.). If you have already experienced losing your hard work at some point then you know how important having a backup is…at all times. Note that you should execute (run) the query for each question only once and do not need to store your queries in SQLiteStudio.

To complete these exercises, you need to consult the textbook (chapter 4) and online help https://www.w3schools.com/sql/. Keywords are included in the assignment to help you locate the related online help for each exercise.

When the questions for this assignment do not specify which rows to show in the results, assume that all rows should be shown. Similarly, when the questions do not specify which columns to show in the results, assume that all columns should be shown. When the questions specify that only certain columns should be included in the results, this does not imply that other columns cannot be used in the query (they should simply not be part of the output).