www.definite.app
Open in
urlscan Pro
76.76.21.123
Public Scan
Submitted URL: http://definiteapp.com/?shiny
Effective URL: https://www.definite.app/?shiny
Submission Tags: shiny c290acadafe6362a fc6b18fd85158e2b bfst honeypoter@gmail.com Search All
Submission: On August 18 via api from JP — Scanned from JP
Effective URL: https://www.definite.app/?shiny
Submission Tags: shiny c290acadafe6362a fc6b18fd85158e2b bfst honeypoter@gmail.com Search All
Submission: On August 18 via api from JP — Scanned from JP
Form analysis
0 forms found in the DOMText Content
🚀 Our Slackbot is live! Click here to sign up and add the integration → Dismiss Open main menu BlogConnector Database Log InSign Up THE DATA ANALYST THAT NEVER SLEEPS DEFINITE IS LIKE WORKING WITH A DATA ANALYST THAT UNDERSTANDS YOUR DATA AND CAN INSTANTLY GET YOU THE INSIGHT YOU NEED. Try Definite Get in touch Play the demo GET YOUR ANSWERS ANYTIME ON SLACK Instead of asking your data team for help, just ask Definite. TEXT TO SQL THAT ACTUALLY WORKS Ask questions in natural language across multiple tables and our engine knows where to join. ITERATE AND VISUALIZE FASTER Ask follow up questions and visualize the results in seconds. YOUR DATA TEAM IS DROWNING Definite ends the flood of adhoc requests so your data engineers and data scientists can finally have time for deep work. Show by user the combined number of comments and stories posted after jan 1 2022 Show by user the combined number of comments and stories posted after jan 1 2022 SELECT users.username, COUNT(comments.id) + COUNT(stories.id) AS total_posts FROM hacker_news.users AS users LEFT JOIN hacker_news.comments AS comments ON users.username = comments.by LEFT JOIN hacker_news.stories AS stories ON users.username = stories.by WHERE comments.timestamp > '2022-01-01' OR stories.timestamp > '2022-01-01' GROUP BY users.username ORDER BY total_posts DESC LIMIT 10 SET UP IN MINUTES (NOT WEEKS) Definite is tightly integrated with the rest of your data stack, making building analytical workflows a breeze. PRICING BasicEverything necessary to get started. * Up to 3 editor users * Unlimited integrations * Unlimited canvases Sign up BusinessEverything in Basic, plus essential tools to equip your business to make data driven decisions. * Slack bot access * Premium support Get in touch EnterpriseEverything in Business, plus support needed for your organization. * SOC2 compliance Get in touch DATA DOESN’T NEED TO BE SO HARD. Get started for free Home Blog Connector Database Data Processing Addendum Privacy Policy Cookie Policy Terms of Service