Search for a query : My queries

Category	Description	SQL	Type	Reference
analytics		SELECT date_trunc('month', o.order_date)::date AS month, SUM(od.unit_price * od.quantity * (1 - od.discount))::numeric(14,2) AS revenue FROM orders o JOIN order_details od USING (order_id) WHERE o.order_date >= DATE '1997-01-01' AND o.order_date < DATE '1998-01-01' GROUP BY 1 ORDER BY 1;
analytics		SELECT c.customer_id, c.company_name, c.country, SUM(od.unit_price * od.quantity * (1 - od.discount))::numeric(14,2) AS revenue FROM orders o JOIN customers c USING (customer_id) JOIN order_details od USING (order_id) GROUP BY c.customer_id, c.company_name, c.country ORDER BY revenue DESC LIMIT 10;
operations		SELECT DISTINCT ON (o.customer_id) o.customer_id, o.order_id, o.order_date FROM orders o ORDER BY o.customer_id, o.order_date DESC;
data_quality		SELECT c.customer_id, c.company_name, c.country FROM customers c LEFT JOIN orders o ON o.customer_id = c.customer_id WHERE o.customer_id IS NULL ORDER BY c.company_name;
exploration		SELECT p.product_id, p.product_name, p.quantity_per_unit, p.unit_price FROM products p WHERE p.product_name ILIKE '%$1%%' ORDER BY p.product_name;