Any help is greatly appreciated!
Code: Select all
id user date purchase
1 john 2008-08-01 apple
2 mary 2008-08-02 apple
3 mary 2008-08-03 peach
4 david 2008-08-03 pear
5 david 2008-08-04 apple
6 john 2008-08-04 peach
7 david 2008-08-05 pear
8 mary 2008-08-05 pear
9 john 2008-08-05 pear
10 john 2008-08-05 appleCode: Select all
user peach apple pear
john 1 2 1
mary 1 1 1
david 1 2 0