Answered step by step
Verified Expert Solution
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 via the warehouse; the profit for bicycles in the Eastern US sold in August through the dealer network; and the profit for bicycles in the Eastern US sold in March through the internet.
HINT : You know how to use DatePart to get year. Month is also part of a date, right? Try using the letter instead of the letters yyyy in your datepart formula and see what happens.
HINT : This one uses pretty much all the query techniques I have shown you: querying queries, setting criteria, making new attributes, ANDOR 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 numbers below.
$
$
$
$
$
$
$
$
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started