Given a table of user clicks and a table of ticket purchases, write a query to calculate the conversion rate per device type.