asked
help me wite query for these question
[link text][1] ![alt text][2] can some one pls write queries to answer the following questions based my design, i have been working on it all day and i am tired i could use some help: a. Find all those customers who have not purchased anything from Niles Video Inc. b. Get the total number of DVDs and video tapes sold per genre. c. Get the average number of DVDs per purchase. [1]: /storage/temp/482-final+project+it+240+11-19-2012.zip [2]: /storage/temp/483-table11.png
a. Find all those customers who have not purchased anything from Niles Video Inc. SELECT CustomerID,Name FROM CustomerINfo CI where customerID not exists( select customerID from OrderQuery oq inner join Movies m on m.itemNumber=oq.itemnumber where Genre='Niles Video Inc') b. Get the total number of DVDs and video tapes sold per genre. > select genre,sum(quantity) from > OrderQuery oq inner join Movies m on > m.itemnumber=oq.itemnumber group by > m.genre c. Get the average number of DVDs per purchase. select Title,avg(sum(quantity)) from Movies m inner join OrderQuery oq on oq.itemnumber=m.itemnumber group by Title
10 People are following this question.
