-- Database schema
| Episode : episode_id [ TEXT ] primary_key , season [ INTEGER ] , episode [ INTEGER ] , number_in_series [ INTEGER ] , title [ TEXT ] , summary [ TEXT ] , air_date [ TEXT ] , episode_image [ TEXT ] , rating [ REAL ] , votes [ INTEGER ] | Person : name [ TEXT ] primary_key , birthdate [ TEXT ] , birth_name [ TEXT ] , birth_place [ TEXT ] , birth_region [ TEXT ] , birth_country [ TEXT ] , height_meters [ REAL ] , nickname [ TEXT ] | Award : award_id [ INTEGER ] primary_key , organization [ TEXT ] , year [ INTEGER ] , award_category [ TEXT ] , award [ TEXT ] , person [ TEXT ] Award.person = Person.name , role [ TEXT ] , episode_id [ TEXT ] Award.episode_id = Episode.episode_id , season [ TEXT ] , song [ TEXT ] , result [ TEXT ] | Character_Award : award_id [ INTEGER ] Character_Award.award_id = Award.award_id , character [ TEXT ] | Credit : episode_id [ TEXT ] Credit.episode_id = Episode.episode_id , category [ TEXT ] , person [ TEXT ] Credit.person = Person.name , role [ TEXT ] , credited [ TEXT ] | Keyword : episode_id [ TEXT ] Keyword.episode_id = Episode.episode_id , keyword [ TEXT ] | Vote : episode_id [ TEXT ] Vote.episode_id = Episode.episode_id , stars [ INTEGER ] , votes [ INTEGER ] , percent [ REAL ] |
-- -- Find the winning rate of award in 2010. Describe the winner name, award name, episode title and role of the winner in that episode.

SELECT T3.rate, T4.person, T4.award, T5.title, T4.role FROM ( SELECT CAST(SUM(CASE WHEN T1.result = 'Winner' THEN 1 ELSE 0 END) AS REAL) / SUM(CASE WHEN T1.result IN ('Winner', 'Nominee') THEN 1 ELSE 0 END) AS rate , T1.person, T1.award, T2.title, T1.role FROM Award AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE SUBSTR(T1.year, 1, 4) = '2010' ) AS T3 INNER JOIN Award AS T4 INNER JOIN Episode AS T5 ON T4.episode_id = T5.episode_id WHERE T4.year = 2010 AND T4.result = 'Winner';