IT 234 IT234 Unit 6 Assignment (Kaplan University)

IT 234 IT234 Unit 6 Assignment (Kaplan University)

BUY HERE⬊

http://mxstudent.com/it-234-it234-unit-6-assignment-kaplan-university/

Part 3: Import data from a file.

Use the Unit6_Import.csv file from the Doc Sharing and import the data into the Movie database.

File imported to the database screenshot:

art 2

1. In alphabetical order by movie title, list all titles and the lead star from the dbo.Movies_Import_Temp table where the star is Humphrey Bogart.

2. List all movie titles, lead star, and producer from dbo.Movies_Import_Temp, where the star is Bing Crosby and group the movies by producer. You should select Title, LeadStar, and Producer so that all fields are displayed.

3. From dbo.Movies_Import_Temp, list all movie titles, genre, and producers that have the genre “Drama”.

4. Write a query that shows how many records are in dbo.Movies_Import_Temp.

Part 3: Install a database from a script file.

Install the Northwind database using the script file called, SQL Server NorthwindDB SQL File, from Doc Sharing.  The script file is an actual query, so you will copy and paste the entire contents of the script file into a new SQL query window in Management Studio. Create a screen shot to show the results of the query execution – that the Northwind database is now showing on the left panel of Management Studio.

Part 6: Create SQL statements

Create SQL statements to retrieve data from the Northwind database

Select Columns

1. Return the CompanyName, Fax, Phone, Country from the Suppliers table

Where Country = ‘Germany’ Sort by CompanyName in default, ascending order

2. Return a list of ContactName, CompanyName, ContactTitle and Country from the Customers table and Group by ContactTitle

3. Return a list of EmployeeID, Title, FirstName, LastName, and Region from

The Employees table sorted by LastName where Title is Sales Representative and Region is WA.