Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. What is the total (SUM) of the Freight for all of the rows? When writing your response, round to two decimal places. 2. Using

1. What is the total (SUM) of the Freight for all of the rows? When writing your response, round to two decimal places.
2. Using the data in this data warehouse, find and list the names of the products customer 11037 has purchased. image text in transcribed
Use Adventureworks2014 or later database DimProduct ProductKey Product Alternatekey ProductSubcategory Key Weight Unit MeasureCode SizeUnit MeasureCode English Product Name Spanish Product Name French Product Name Standard Cost Finished Goodslag DimDate Datkey FulDate Alternatekey DayNumberOfWeek English DayNameOfWeek SpanishDayNameOfWeek French DayNaOweek DayNumberOfMonth DayNumberOfear WeekNumberOle English MonthName Spanish MonthName French Month Name Month Number CalendarQuarter CalendarYear Calendarsemester FiscalQuarter Fiscal Year FiscalSemester Color Factinternet Sales ProductKey Ondertekey DueDateKey Ship Datkey Customerkey Promotion key Currencykey Sales Territory Key Sales Order Number SalesOrderline Number Revision Number Order Quantity Unit Price Extended Amount UnitPrice contact Discount Amount Product Standard Cost TotalProductos Samount TA Freight Carrier TrackingNumber Customer Number Order Date DuaDate ShipDate Safety StockLevel ReorderPoint UstPrice DimCustomer Customerkey Geography Key Customer Alternate Key Range Weight DaysToManufacture ProductLine Dealer Price Class Style Model Name Large Photo English Description French Description Chinese Description Arabi Deiption Hebrew Description Thai Description German Description japanese Description Turkish Description StartDate EndDate Status FirstName MidName LastName NameStyle BirthDate Marital Status Suffix Gender Email Address Yearlyn.com TotalChidon NumberChildrenAtHome EnglishEducation Spanish Education Frencheducation English Occupation Spanish Occupation French Occupation House Ownerfing NumberCarsOwned AddressLine1 AddressLine2 Phone DateFirst Purchase CommuteDistance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 25th European Conference Adbis 2021 Tartu Estonia August 24 26 2021 Proceedings Lncs 12843

Authors: Ladjel Bellatreche ,Marlon Dumas ,Panagiotis Karras ,Raimundas Matulevicius

1st Edition

3030824713, 978-3030824716

More Books

Students also viewed these Databases questions

Question

Explain the various techniques of Management Development.

Answered: 1 week ago