Qualify & Score Your B2B Leads. Turbocharged.

ployee_count FROM departments d LEFT JOIN employees e ON d.department_id = e.department_id GROUP BY d.department_name HAVING employee_count > 10 ORDER BY employee_count DESC SELECT d.department_name, COUNT(e.employee_id) as em

ployee_count FROM departments d LEFT JOIN employees e ON d.department_id = e.department_id GROUP BY d.department_name HAVING employee_count > 10 ORDER BY employee_count DESC SELECT d.department_name, COUNT(e.employee_id) as em

ESC, comment_count DESC SELECT u.name, COUNT(DISTINCT p.post_id) as post_count, COUNT(DISTINCT c.comment_id) as comment_count FROM users u LEFT JOIN posts p ON u.user_id = p.user_id LEFT JOIN comments c ON u.user_id = c.user_id GROUP BY u.name HAVING post_count >= 5 AND comment_count >= 10 ORDER BY post_count D

ESC, comment_count DESC SELECT u.name, COUNT(DISTINCT p.post_id) as post_count, COUNT(DISTINCT c.comment_id) as comment_count FROM users u LEFT JOIN posts p ON u.user_id = p.user_id LEFT JOIN comments c ON u.user_id = c.user_id GROUP BY u.name HAVING post_count >= 5 AND comment_count >= 10 ORDER BY post_count D

tag_name ORDER BY related_post_count DESC SELECT t1.tag_name, COUNT(t2.post_id) as related_post_count FROM tags t1 JOIN post_tags pt1 ON t1.tag_id = pt1.tag_id JOIN post_tags pt2 ON pt1.post_id = pt2.post_id AND pt1.tag_id != pt2.tag_id JOIN tags t2 ON pt2.tag_id = t2.tag_id GROUP BY t1.

tag_name ORDER BY related_post_count DESC SELECT t1.tag_name, COUNT(t2.post_id) as related_post_count FROM tags t1 JOIN post_tags pt1 ON t1.tag_id = pt1.tag_id JOIN post_tags pt2 ON pt1.post_id = pt2.post_id AND pt1.tag_id != pt2.tag_id JOIN tags t2 ON pt2.tag_id = t2.tag_id GROUP BY t1.

_id = p.product_id GROUP BY order_year, order_month SELECT YEAR(o.order_date) as order_year, MONTH(o.order_date) as order_month, SUM(od.quantity * p.price) as total_sales FROM orders o JOIN order_details od ON o.order_id = od.order_id JOIN products p ON od.product

_id = p.product_id GROUP BY order_year, order_month SELECT YEAR(o.order_date) as order_year, MONTH(o.order_date) as order_month, SUM(od.quantity * p.price) as total_sales FROM orders o JOIN order_details od ON o.order_id = od.order_id JOIN products p ON od.product

tudent_id, s1.name, s2.course_id HAVING average >= 80 ORDER BY average DESC SELECT s1.student_id, s1.name, s2.course_id, AVG(s2.grade) as average FROM students s1 INNER JOIN student_courses s2 ON s1.student_id = s2.student_id GROUP BY s1.s

tudent_id, s1.name, s2.course_id HAVING average >= 80 ORDER BY average DESC SELECT s1.student_id, s1.name, s2.course_id, AVG(s2.grade) as average FROM students s1 INNER JOIN student_courses s2 ON s1.student_id = s2.student_id GROUP BY s1.s

as book_count, AVG(r.rating) as average_rating FROM authors a JOIN books b ON a.author_id = b.author_id JOIN book_ratings r ON b.book_id = r.book_id GROUP BY a.author_name HAVING book_count > 10 ORDER BY average_rating DESC SELECT a.author_name, COUNT(b.book_id)

as book_count, AVG(r.rating) as average_rating FROM authors a JOIN books b ON a.author_id = b.author_id JOIN book_ratings r ON b.book_id = r.book_id GROUP BY a.author_name HAVING book_count > 10 ORDER BY average_rating DESC SELECT a.author_name, COUNT(b.book_id)

r_id) as customer_count FROM products p1 JOIN order_details od1 ON p1.product_id = od1.product_id JOIN orders o ON od1.order_id = o.order_id JOIN order_details od2 ON o.order_id = od2.order_id AND od1.product_id != od2.product_id JOIN products p2 ON od2.product_id = p2.product_id GROUP BY p1.name, p2.name ORDER BY customer_count DESC SELECT p1.name as product, p2.name as related_product, COUNT(distinct o.custome

r_id) as customer_count FROM products p1 JOIN order_details od1 ON p1.product_id = od1.product_id JOIN orders o ON od1.order_id = o.order_id JOIN order_details od2 ON o.order_id = od2.order_id AND od1.product_id != od2.product_id JOIN products p2 ON od2.product_id = p2.product_id GROUP BY p1.name, p2.name ORDER BY customer_count DESC SELECT p1.name as product, p2.name as related_product, COUNT(distinct o.custome

id = e.city_id GROUP BY c.name HAVING event_count >= 5 ORDER BY total_attendees DESC SELECT c.name, COUNT(e.event_id) as event_count, SUM(e.attendees) as total_attendees FROM cities c JOIN events e ON c.city_

id = e.city_id GROUP BY c.name HAVING event_count >= 5 ORDER BY total_attendees DESC SELECT c.name, COUNT(e.event_id) as event_count, SUM(e.attendees) as total_attendees FROM cities c JOIN events e ON c.city_

= b.date WHERE a.date >= '2022-01-01' AND a.date <= '2022-12-31' GROUP BY a.room_id, a.date HAVING booking_count < a.capacity ORDER BY a.date SELECT a.room_id, a.date, COUNT(b.booking_id) as booking_count FROM availability a LEFT JOIN bookings b ON a.room_id = b.room_id AND a.date

= b.date WHERE a.date >= '2022-01-01' AND a.date <= '2022-12-31' GROUP BY a.room_id, a.date HAVING booking_count < a.capacity ORDER BY a.date SELECT a.room_id, a.date, COUNT(b.booking_id) as booking_count FROM availability a LEFT JOIN bookings b ON a.room_id = b.room_id AND a.date