BuddyPress.org

Hi i have installed plugin, Mymoods on buddypress how can i show the statics of no of smiley used mostly, i have written small query to retrieve the data which i needed, how i can i write in buddypress or wordpress to convert what i want,
Here is the query
“SELECT `meta_value` , COUNT( * ) AS count
FROM `wp_bp_activity_meta`
WHERE `meta_key` = ‘mymood_mood’
GROUP BY `meta_value`
ORDER BY `count` DESC
LIMIT 0 , 30
”
I have red through the wordpress site http://codex.wordpress.org/Class_Reference/wpdb but not able to show any results, sorry for my english, any pointer how to start would be very helpful