Merging two SQL queries into one

gistfile1.txt

I want to divide the correct count by total count (where the domain names match)

/* Get the total count */

SELECT DISTINCT(domain_name), COUNT(*) AS count
FROM recommendations
WHERE rec_date LIKE '2007%'
GROUP BY domain_name
ORDER BY count DESC;


/* Get the correct count */

SELECT DISTINCT(domain_name), COUNT(*) AS count
FROM recommendations
WHERE rec_date LIKE '2007%' AND direction = 'positive' AND adj_ret1d > 0
   OR rec_date LIKE '2007%' AND direction = 'negative' AND adj_ret1d < 0
GROUP BY domain_name
ORDER BY count DESC;