code snippet Prompts

Cursor Prompt: Complex SQL Query Generation & Optimization

Generate an optimized SQL query for the following database schema and problem description. The goal is to [detailed description of desired data retrieval, aggregations, joins, filtering, and ordering]. After generating the initial query, provide a second, more optimized version if possible, explaining the performance gains. Also, suggest potential indexing strategies on relevant columns that would further enhance query speed. Assume a large dataset.

Database Schema (simplified):

-- [User pastes relevant CREATE TABLE statements here, e.g.]
CREATE TABLE Orders (
    order_id INT PRIMARY KEY,
    customer_id INT,
    order_date DATE,
    total_amount DECIMAL(10, 2)
);

CREATE TABLE Customers (
    customer_id INT PRIMARY KEY,
    customer_name VARCHAR(255),
    city VARCHAR(100)
);

CREATE TABLE Products (
    product_id INT PRIMARY KEY,
    product_name VARCHAR(255),
    category VARCHAR(100),
    price DECIMAL(10, 2)
);

CREATE TABLE OrderItems (
    order_item_id INT PRIMARY KEY,
    order_id INT,
    product_id INT,
    quantity INT
);

Cursor Prompt: Multi-File Feature Implementation

Implement a new feature across these existing JavaScript files. The feature involves [brief description of the feature]. You'll need to modify the provided main.js to [specific action in main.js], api.js to [specific action in api.js], and utils.js to [specific action in utils.js]. Ensure the new code integrates seamlessly with the existing structure, adheres to best practices (e.g., asynchronous operations, error handling, modularity), and includes appropriate comments. Provide the updated content for each file.

User will paste content from multiple files into the chat, separated by clear markers like --- api.js ---, --- main.js ---, etc.

// --- main.js ---
// [User pastes main.js content]

// --- api.js ---
// [User pastes api.js content]

// --- utils.js ---
// [User pastes utils.js content]