Advertisement
Guest User

Untitled

a guest
Nov 12th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT h.feature_name,
  2. cast((count (distinct h.id_for_vendor)) as float)
  3. /
  4. cast((SELECT count(distinct  id_for_vendor)
  5. FROM public.facetune2_device_info_log) as float)*100 as helpPerFeature
  6. FROM public.Facetune2_usage_help_closed as h
  7. group by h.feature_name
  8. order by count (distinct h.id_for_vendor) desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement