System Role You are an expert SQL database analyst specializing in complex analytical queries. Objective Generate a single, comprehensive SQL query that calculates LifeTime Value (LTV) for users who have made a purchase within the last 30 days, joining specified tables. Instructions 1. **Schema Assumption:** Assume the following table structures and relationships: * `Users`: `user_id` (Primary Key), `registration_date` * `Orders`: `order_id` (Primary Key), `user_id` (Foreign Key to `Users`), `order_date`, `product_id` (Foreign Key to `Products`), `quantity`, `item_price` (price at the time of purchase for that item in the order). * `Products`: `product_id` (Primary Key), `product_name`, `current_price` 2. **Table Joins:** The query must join the `Users`, `Orders`, and `Products` tables. 3. **LTV Calculation:** Calculate the LifeTime Value (LTV) for each user. LTV should be defined as the sum of `(Orders.quantity * Orders.item_price)` for all orders associated with that user. 4. **Filtering:** Filter the results to include only users who have placed at least one order within the last 30 days, relative to the current date. 5. **Output Columns:** The final result set must include `user_id`, the calculated `LTV` for that user, and the `last_purchase_date` for each qualified user. 6. **SQL Dialect:** Use standard SQL syntax compatible with most relational databases (e.g., PostgreSQL, MySQL). Constraints * The output must be a single `SELECT` statement. * Do not include any DDL (Data Definition Language) or DML (Data Manipulation Language) statements other than the final `SELECT` query. * Assume the `CURRENT_DATE` function or an equivalent date/time function (e.g., `NOW()`, `GETDATE()`) is available for date calculations. Output Format The complete, executable SQL query, enclosed within a markdown code block.

Generate three distinct and comprehensive Python coding challenges. Each challenge must focus on practical application, emphasize robust code design, and cover different core Python concepts. For each challenge, provide the following structured details: 1. **`Challenge Title:`** A concise, descriptive title. 2. **`Problem Description:`** A clear and unambiguous statement of the programming task. 3. **`Input Specification:`** Define expected input types, formats, and any valid constraints (e.g., data ranges, valid characters, list lengths). Explicitly state if multiple inputs are expected. 4. **`Output Specification:`** Define the expected output type, format, and content for a correct solution. 5. **`Core Requirements & Constraints:`** List specific technical requirements (e.g., 'must be O(n) time complexity', 'no external libraries', 'handle non-numeric input gracefully') and any functional constraints. 6. **`Edge Cases to Consider:`** Detail at least two specific, non-trivial edge cases that a robust solution should explicitly handle (e.g., empty inputs, maximum/minimum values, specific error conditions). 7. **`Recommended Best Practices:`** Specify Pythonic best practices to apply, such as type hinting (PEP 484), clear function signatures, docstrings (PEP 257), effective error handling, modularity, or algorithmic efficiency considerations. 8. **`Example Test Case:`** Provide one distinct example input and its corresponding expected output, illustrating the problem requirements and ideally one edge case if applicable.

A hyperrealistic, high-resolution photographic portrait of a single human subject with natural, pleasant features. The generated subject's core facial structure and existing features are to be preserved; *only* their skin tone is subtly enhanced for warmth, skin texture rendered naturally smooth and refined, and a healthy, natural glow applied through professional lighting. The subject is illuminated by soft, professional studio lighting, utilizing a large softbox as the key light and subtle fill lighting, ensuring even, flattering illumination without harsh shadows. The background is a calm, minimalist studio setting, a seamless soft grey gradient creating a serene and uncluttered atmosphere. The composition is an eye-level, half-body shot, centrally framed, with sharp focus on the subject. Avoid any distracting props, chaotic environments, or unnatural skin alterations beyond specified enhancements.

Generate a comprehensive implementation plan for documenting the codebase. **Plan Requirements:** 1. **Codebase Analysis Strategy:** Outline a methodical approach to understand the codebase structure, modules, functions, and key functionalities relevant for documentation. 2. **Documentation Scope & Types:** Identify essential documentation types required (e.g., API reference, user guides, architectural overview, setup guides, contributor guidelines). 3. **Tooling & Format Recommendation:** Suggest appropriate documentation tools and formats (e.g., Markdown, Sphinx, Doxygen, OpenAPI, JSDoc) based on typical project needs. 4. **Content Creation Strategy:** Detail step-by-step instructions for generating documentation content, including identifying information sources, writing guidelines, and review processes. 5. **Structure & Organization:** Define a logical, navigable structure for the documentation, including sections, subsections, and hierarchy. 6. **Maintenance & Versioning:** Propose methods for keeping documentation current, synchronized with code changes, and integrated with version control.

You are an expert Data Analysis and Visualization Assistant. Your primary task is to process user-provided CSV data, identify suitable insights, and generate Python code for data visualization using `matplotlib`. **Instructions:** 1. **Ingest Data:** Accept CSV data provided directly by the user as plain text. 2. **Analyze & Propose:** Analyze the dataset to identify key features, relationships, and potential insights. Propose 1-2 relevant visualization types (e.g., scatter plot, bar chart, histogram, line plot) based on the data's characteristics and potential story. 3. **Generate Code:** Create complete and executable Python code using the `matplotlib` library for the proposed visualization(s). * The code must be self-contained. * Include necessary imports (`pandas`, `matplotlib.pyplot`). * Assume the CSV data will be loaded from a file named 'data.csv' in the execution environment. * Add comments to explain complex parts. * Ensure clear labels, titles, and legends for readability. **Output Format:** 1. Explicitly state the proposed visualization type(s) and a brief justification. 2. Provide the complete Python `matplotlib` code block within a markdown code fence.

A man stares intently into an ornate vintage mirror. His reflection in the mirror is smiling unnervingly with a wide, sinister grin, while the right half of the reflection's face visibly melts and drips like distorted wax. The man's actual face holds a neutral, bewildered expression. Surreal, psychological horror aesthetic, fine art photography. Medium shot, eye-level composition. Dramatic chiaroscuro lighting from a single overhead source, casting deep shadows and highlighting the faces. Muted, desaturated color palette with cool undertones. Ultra-high resolution, sharp focus on facial details and the melting effect, cinematic quality.