Re: SQL help
Babey Yaar professor gave several question and every question has something added to it. For example, the first question is:
- For each type of book, list the type and the average price
- Repeat 1 but consider only paperback books
- Repeat 1 and 2 but consider only paperback books for which the avg. price > 10.
and so on 
Bandoostaa Thanks. It solved the problem.
Umer bhai Thanks a lot yaar. I guess the only thing I was missing was Group By.
Bandoostaa & Umer bhai Thanks for the suggestions. Although I have to use SQL only for this class, but it’s an interesting language and I plan to learn it just for the heck for it. I did read about all those basic functions and now I seem to understand it. It’ll take a lot of practice before I come anywhere near the amount of expertise you all have in it.
Mansoor Thanks for your suggestion bro 
I’ve solved all of the problems except this last one and I am NOT going to get help on it. I will answer this sucker myself and I don’t care how long it takes me 