Report Portal

By using adventureworks 2008 r2 database

By using adventureworks 2008 r2 database , how we can find about the particular product being sold most in which city. For example... Toyota cars are bein sold most In Calgary. And at second position it is being sold by Toronto etc. I tried but I couldn't get exact query..mine is 90% right can you give me query for above report subject. Thanks.

 

2007-2015 VidasSoft Systems Inc.