Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Why is it that I got 0 Row with nothing showing up? Is there a flow in my logic? Using AdventureWorks DW2017, list all the

Why is it that I got 0 Row with nothing showing up? Is there a flow in my logic?
imageimage

Using AdventureWorks DW2017, list all the Canadian customers who have spent more than $5,000 total. Show Customerkey, FirstName, LastName, and total sales amount rounded to 2 decimal places. Sort by the total sales amount in descending order. Include the code you used to determine the answer. 16 points I got 42 rows Question: What is the name of the first name in record 2? Put your answer here ==>

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_2

Step: 3

blur-text-image_3

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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students explore these related Databases questions