Using the sample data as a guide, how would you write a TSQL statement that lists the number of each product type purchased by each customer for the month of February 2012. Here is what the resulting data set would look like:
CustomerID FirstName LastName NumAutoTires NumDrills NumBatteries NumMotorOil
1 Steve Smith 4 0 10 1
2 John McLean 2 2 0 18
3 Peter Harrington 1 1 2 4
4 Wendy Foster 4 0 8 0
How would you write it?
We don't do homework here.
Share your attempts first and we can help nudge you in the right direction.
If you're not willing to put the effort in, neither are we. But if you try - I think you'll be very happy