Avanty

FeaturesPricingDocumentationDocsFAQsChangelogLoginGet started todayNow in Early Access Your intelligent Copilot for Metabase Avanty is an AI-powered Chrome extension that supports data analysts in their work in Metabase. Save time on generating, editing and understanding SQL.Get started for freeCheck out the featuresployeecount FROM departments d LEFT JOIN employees e ON d.departmentid = e.departmentid GROUP BY d.departmentname HAVING employeecount > 10 ORDER BY employeecount DESC SELECT d.departmentname, COUNT(e.employeeid) as employeecount FROM departments d LEFT JOIN employees e ON d.departmentid = e.departmentid GROUP BY d.departmentname HAVING employeecount > 10 ORDER BY employeecount DESC SELECT d.departmentname, COUNT(e.employeeid) as emESC, commentcount DESC SELECT u.name, COUNT(DISTINCT p.postid) as postcount, COUNT(DISTINCT c.commentid) as commentcount FROM users u LEFT JOIN posts p ON u.userid = p.userid LEFT JOIN comments c ON u.userid = c.userid GROUP BY u.name HAVING postcount >= 5 AND commentcount >= 10 ORDER BY postcount DESC, commentcount DESC SELECT u.name, COUNT(DISTINCT p.postid) as postcount, COUNT(DISTINCT c.commentid) as commentcount FROM users u LEFT JOIN posts p ON u.userid = p.userid LEFT JOIN comments c ON u.userid = c.userid GROUP BY u.name HAVING postcount >= 5 AND commentcount >= 10 ORDER BY postcount Dtagname ORDER BY relatedpostcount DESC SELECT t1.tagname, COUNT(t2.postid) as relatedpostcount FROM tags t1 JOIN posttags pt1 ON t1.tagid = pt1.tagid JOIN posttags pt2 ON pt1.postid = pt2.postid AND pt1.tagid != pt2.tagid JOIN tags t2 ON pt2.tagid = t2.tagid GROUP BY t1.tagname ORDER BY relatedpostcount DESC SELECT t1.tagname, COUNT(t2.postid) as relatedpostcount FROM tags t1 JOIN posttags pt1 ON t1.tagid = pt1.tagid JOIN posttags pt2 ON pt1.postid = pt2.postid AND pt1.tagid != pt2.tagid JOIN tags t2 ON pt2.tagid = t2.tagid GROUP BY t1.id = p.productid GROUP BY orderyear, ordermonth SELECT YEAR(o.orderdate) as orderyear, MONTH(o.orderdate) as ordermonth, SUM(od.quantity * p.price) as totalsales FROM orders o JOIN orderdetails od ON o.orderid = od.orderid JOIN products p ON od.productid = p.productid GROUP BY orderyear, ordermonth SELECT YEAR(o.orderdate) as orderyear, MONTH(o.orderdate) as ordermonth, SUM(od.quantity * p.price) as totalsales FROM orders o JOIN orderdetails od ON o.orderid = od.orderid JOIN products p ON od.producttudentid, s1.name, s2.courseid HAVING average >= 80 ORDER BY average DESC SELECT s1.studentid, s1.name, s2.courseid, AVG(s2.grade) as average FROM students s1 INNER JOIN studentcourses s2 ON s1.studentid = s2.studentid GROUP BY s1.studentid, s1.name, s2.courseid HAVING average >= 80 ORDER BY average DESC SELECT s1.studentid, s1.name, s2.courseid, AVG(s2.grade) as average FROM students s1 INNER JOIN studentcourses s2 ON s1.studentid = s2.studentid GROUP BY s1.s as bookcount, AVG(r.rating) as averagerating FROM authors a JOIN books b ON a.authorid = b.authorid JOIN bookratings r ON b.bookid = r.bookid GROUP BY a.authorname HAVING bookcount > 10 ORDER BY averagerating DESC SELECT a.authorname, COUNT(b.bookid) as bookcount, AVG(r.rating) as averagerating FROM authors a JOIN books b ON a.authorid = b.authorid JOIN bookratings r ON b.bookid = r.bookid GROUP BY a.authorname HAVING book_count > 10