Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Find the profit for bicycles in the Western US sold in May 2 0 2 1 via the warehouse; the profit for bicycles in the

Find the profit for bicycles in the Western US sold in May 2021 via the warehouse; the profit for bicycles in the Eastern US sold in August 2019 through the dealer network; and the profit for bicycles in the Eastern US sold in March 2017 through the internet.
HINT 1: You know how to use DatePart to get year. Month is also part of a date, right? Try using the letter m instead of the letters yyyy in your datepart formula and see what happens.
HINT 2: This one uses pretty much all the query techniques I have shown you: querying queries, setting criteria, making new attributes, AND/OR logic so break this down into its component pieces. You know you can query queries, but you can also query queries that query a query. Your final query should have just three rows. Mine did. Pick those 3 numbers below.
$156,560
$4,349,700
$26,520,250
$277,500
$19,706,280
$21,259,230
$217,780
$233.590
image text in transcribed

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

Database Concepts

Authors: David M Kroenke, David J Auer

6th Edition

0132742926, 978-0132742924

More Books

Students also viewed these Databases questions