SELECT s.order_date, c.customer_name, p.product_name, s.quantity, s.total_amount FROM sales s JOIN customers c USING (customer_id) JOIN products p USING (product_id) ORDER BY s.order_date DESC LIMIT 100;