Question: SQL Part 1 Using the WideWorldImporters database and the Sales schema select CustomerName, CreditLimit, PhoneNumber from the table Customers and the corresponding CustomerCategoryName, ValidFrom, and

SQL

Part 1 Using the WideWorldImporters database and the Sales schema select CustomerName, CreditLimit, PhoneNumber from the table Customers and the corresponding CustomerCategoryName, ValidFrom, and ValidTo from the CustomerCategories table. Review the columns to determine how to join the tables.

Take a screen shot of the SQL windows and results and paste it here.

Part 2 Using the AdventureWorks database and the Production schema, select the Name from the Product table, the Name from the ProductSubcategory table, and the Name and ModifiedDate from the ProductModel table. Use appropriate aliases to distinguish the Name columns from each table. Review the columns in each table to determine how to join the tables.

Take a screen shot of the SQL windows and results and paste it here.

Part 3 Using WideWorldImporters and the Sales schema select the CustomerName for the table Customers and the CustomerCategoryName from the table CustomerCategories showin all categories with or without customers. Review the columns in each table to determine how to join the tables.

Take a screen shot of the SQL windows and results and paste it here.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I need the SQL code for each part with a screen shot Writing Queries against XML and JSON Data. This is the example Part 1 Using the WideWorldImporters database and the Warehouse schema write a query...

Sql Programing Part 1 Using WideWorldImporters and the Warehouse schema add the following values to the Colors table for the columns ColorName and LastEditedBy: Dark Gray, 1; Scarlet, 1; Light Gray,...

Use the ' Premiere Products Company ' SQL script file found in the D2L content folder called 'SQL Scripts'. Paste the contents of this script into a query tab of MySQL Workbench and execute it. This...

Part 1 Using the WideWorldDistributors database and the Sales schema create a function that takes InvoiceID as an input parameter and returns all the rows from the table InvoiceLines for the...

Topic 6 Query included at the bottom. Please assist as much as possible. Details: The purpose of this assignment is to update a previous query and present it in an easily readable format. For this...

Part 1 Using the WideWorldImporters database, select all rows from the table Colors in the schema Warehouse where the ColorID is between 1 and 15 and combine with all rows where the ColorID is...

Part 1 Using the WideWorldImporters database and the Warehouse schema write a query that returns the result set transformed to XML data. The query will return StockItemID, StockItemName, Brand, Size,...

Working Data Types and Handling NULL Values SQL Part 1 Write a single query to show the results of the following attempts to cast data: Casting a date literal to an int data type will display Fail...

In many companies executive compensation is linked to the companys annual TRS (or margin of TRS above its peers). Discuss pros and cons of using TRS as a basis for executive compensation.

Two scholars are locked in debate regarding the interpretation of the accompanying data. One insists that the relationship between the age of a child and the childs perception of the parents is very...

If you start saving for retirement only in your later years and your income growth from that point is rapid and a traditional retirement plan is probably a better choice than a Roth retirement plan...

Please write full code and show if it works in work space. 2. Check the formula of converting Fahrenheit degree to Celcius degree and write a function called FtoC that will take in the Fahrenheit and...