View difference between Paste ID: 0YPj8KTs and hWvNgsfB

-// Hide all premium questions in https://platform.stratascratch.com/coding?questionType=2
+-- https://platform.stratascratch.com/coding/10285-acceptance-rate-by-date
-// confirmed to work on April 5 2022
+
-// run in browser console
+with sent as (
-var all_locks = document.querySelectorAll('i.fa.fa-lock[style="color: gold;"]');
+    select
-all_locks.forEach(function(el){ el.parentNode.parentNode.parentNode.parentNode.remove(); });
+        date as datesent,
         user_id_sender||user_id_receiver as requestid
     from fb_friend_requests
     where action='sent'
     order by 1 asc),
 
 accepted as (
     select
         date as dateaccepted,
         user_id_sender||user_id_receiver as requestid
     from fb_friend_requests
     where action='accepted'
     order by 1 asc
 )
 
 select datesent as date,
         count(dateaccepted)::FLOAT / count(datesent)::FLOAT as percentage_acceptance
 from sent s
 left join accepted a
 on s.requestid = a.requestid
 group by 1
 order by 1 asc