3 ms·
> Seems like the most basic of OLAP queries and two days of effort would reveal very suspicious userbase. What would those queries look like?
by cactusplant7374 1y ago
> Seems like the most basic of OLAP queries and two days of effort would reveal very suspicious userbase.
What would those queries look like?
- deleted 1y ago[deleted]
- jon-wood 1y agoSELECT COUNT(*) FROM users would have been a start from the sound of it.
- cactusplant7374 1y ago> Meanwhile, Amar purchased a list of 4.5 million real college students and their data from ASL Marketing for $105,000. Frank executives later supplemented that list — which only had email addresses for a portion of the students — by purchasing more data from an information services company. https://www.highereddive.com/news/jpmorgan-chase-alleges-ed-tech-firm-faked-student-accounts-frank/640325/ https://www.highereddive.com/news/jpmorgan-chase-alleges-ed-...
- TuringNYC 1y agoSELECT USER_ID,COUNT(*) FROM WEBSITE_CLICKSTREAM GROUP BY USER_ID
- sontek 1y agoSELECT COUNT(*) FROM users WHERE date_deleted IS NULL AND date_last_activity >= CURRENT_DATE - INTERVAL '120 days';
- duxup 1y agoI don't think that would work, the stories said they generated fake data. There would be users presumably.