slavyan887

Untitled

Sep 15th, 2021
602
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select count(*)
  2.    from (
  3.    select word,
  4.    iif(freq >= round(avg(freq)), 'frequent', 'rare') as f
  5.    from words
  6.    group by word)
  7.    where word like %' and f = 'frequent';
  8.  
RAW Paste Data