SHARE
TWEET

Checked but still no guarantee

a guest Oct 22nd, 2019 141 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT r2, response, avg(recommend) FROM cc3.evisits JOIN cc3.scale ON evisits.r2=scale.rcode GROUP BY r2, response ORDER BY r2;
  2.  
  3. SELECT recommend, (AVG(r1)+AVG(r2)+AVG(r3)+AVG(r4)+AVG(r5))/5 FROM cc3.evisits JOIN cc3.scale ON scale.rcode=evisits.r2 WHERE type=2 group by recommend;
  4.  
  5. SELECT startdate, count(*), avg(recommend) FROM cc3.evisits WHERE resolved='Yes' GROUP BY startdate HAVING count(*)>=5 ORDER BY startdate;
  6.  
  7. SELECT count(*), avg(s1visual), inckey.incomerange FROM cc4.survey JOIN cc4.inckey ON inckey.inc=survey.inc group by inckey.incomerange order by avg(s1visual) desc;
  8.  
  9. SELECT education, hispanic, count(*), avg(s1readability), avg(s2readability) FROM cc4.survey JOIN cc4.edukey ON edukey.edu=survey.edu WHERE sex='Female' GROUP BY education, hispanic HAVING avg(s1readability)>6 AND avg(s2readability)>6 ORDER BY avg(s2readability) desc;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top