CareerCup

select rides.name, count(*) as votes from persons left join rides on persons.favorite_ride_id = rides.id group by persons.favorite_ride_id order by votes limit 10;

SELECT rid.name, cnt.votes
FROM rides AS rid
  INNER JOIN
    (
	  SELECT favorite_ride_id, count(1) AS votes
	  FROM persons
	  GROUP BY favorite_rid_id
    ) AS cnt
        ON cnt.favorite_ride_id = rid.id
ORDER BY cnt.votes DESC

SELECT rides.name, COUNT(persons.favorite_ride_id) AS votes FROM persons INNER JOIN rides ON persons.`favorite_ride_id`=rides.`id`
GROUP BY rides.`id` ORDER BY COUNT(persons.favorite_ride_id) DESC LIMIT 10;

SELECT persons.first_name, persons.last_name, rides.name
  FROM persons
  INNER JOIN rides
    ON rides.id = persons.favorite_ride_id
  INNER JOIN
  (
    SELECT persons.favorite_ride_id, COUNT(*) AS num_votes
    FROM persons
    GROUP BY persons.favorite_ride_id
    ORDER BY num_votes DESC
    LIMIT 10
  ) AS top
  ON top.favorite_ride_id = persons.favorite_ride_id
  ORDER BY top.num_votes DESC;

sel r.name,count(*) as votes from rides r
     left join persons p on
     r.id=p.favorite_ride_id group by votes order by votes desc limit 10

Pls correct me if i m wrong

select top(10) r.name, count(r.id) as vote
from Persons P INNER JOIN Rides R
ON P.favorite_ride_id = R.id
group by name
order by vote desc

Please tell me, if it is correct.

select top 10 count(pr.favRideId), fr.Name from Person pr inner join FavRides fr
on pr.favRideId = fr.id 
group by fr.Name
order by count(pr.favRideId) desc

select r.name,s.votes from rides r,(select id,count(*) as votes from persons group by id desc) s where s.id=r.id limit 10;

SELECT * FROM (SELECT r.name, COUNT(r.id) AS votes FROM persons p, rides r WHERE p.favourite_ride_id = r.id GROUP BY r.id) AS inner_table ORDER BY votes DESC