Im having problem figuring out how to ask my problem i think its best to just give the sample data and my expected result.
here is the data:
here's the result i want to have:
any help please! =)
and also where can you suggest a site for advance or complex SQL articles, tutorial or forum.