Hi dear,

I need help with my SQL Homework. There is data base online sql$-$practice easy to find.

in there, I need to design $2$ Very Challenging Queries from the NorthWind Database

First, describe the business need for the query you are selecting. What would motivate a business leader to want that kind of information?

Second, describe this query in replicable and documentable terms. That is$,$ could someone follow the query you wrote via code and code annotations?

Third, provide the code and walk the reader through each of your queries.

Criteria for your two queries:

$1.$ The query must have three tables with the appropriate joins.

$2.$ The query must use at least $1$ standard SQL function. You can also pick functions that are outside of the learning lab $($if they are supported$).$

$3.$ The query should have a multi$-$statement where such as$,$ Where &$,$ OR$,$ NOT $,$ Etc...

$4.$ The query must run when it is run by an independent analyst.

Thank you! any help will be much appreciate!