fareedhmohamed (4/16/2016)

---

I am not sure how to write a query, that will display the customer who has more than one order in the order table. I have attached the table...

djmenon21 (4/17/2016)

---

I have given it a thought but couldn't come up with anything..Hence i posted this

Can someone please help me build this ?

I have just pretty basic knowledge of SQL...

djmenon21 (4/17/2016)

---

Try to write the simplest query that fully answers the question, avoiding unnecessary complexity.

These tables from our data warehouse provide enough information to answer (you may not need all...

Hi...can you please post some table/data scripts as per post below.

Also your expected results based on the sample data you provide.

Thanks

Helps us help you

https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

great start...now some sample data please and your expected results based on that sample data.

by all means do...it will probably help us help you

oh ...and by the way, I am afraid that screen shots arent the best way of providing data....they can visually explain what you are attempting, but it far better...

personally I wouldnt put a trigger on the order/orderdetails tables...I would probably get the front end application to do the necessary calculations PRIOR to writing to the back end tables...

which one is correct?

fareedhmohamed (4/16/2016)

---

I am not sure how to write a query, that will display the customer who has more than one order in the order table. I have attached the table...

How have you decided your statement above is correct?

can you post the actual execution plan please.

quick scan thro your code....

case when

1 = 1

...

how to present a question with easy to use script for all .

https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

voila:

CREATE TABLE Bball_Stats(

PlayerId INTEGER NOT NULL PRIMARY KEY...

smiF (4/14/2016)

---

(I need to be pointed in the right direction on this)

a.Find the Most Points scored per game by Position

b.Find the Number of Rebounds per game by Coach

NOW, I know...

if it was in Exeter, then I would go as well, never...