SQL Lead

Why SQL Lead is important

-- Example using PostgreSQL
-- Create a table with an INTERVAL column
CREATE TABLE project_duration (
    project_id SERIAL PRIMARY KEY,
    project_name VARCHAR(255),
    duration INTERVAL
);

-- Insert data into the table
INSERT INTO project_duration (project_name, duration) VALUES
('Project A', '1 year 2 months'),
('Project B', '3 weeks'),
('Project C', '10 days 12 hours');

-- Query the table to retrieve project durations
SELECT project_name, duration FROM project_duration;

-- Calculate the difference between two timestamps (PostgreSQL specific)
SELECT TIMESTAMP '2024-01-15 10:00:00' - TIMESTAMP '2023-12-20 09:00:00' AS time_difference;

-- Example using MySQL (Note different syntax for INTERVAL)
-- Create a table with an INTERVAL column
CREATE TABLE order_processing_time (
    order_id INT PRIMARY KEY,
    processing_time INTERVAL
);

-- Insert data into the table
INSERT INTO order_processing_time (order_id, processing_time) VALUES
(1, INTERVAL '1 10:00:00' DAY_HOUR);

-- Query the table to retrieve processing times
SELECT order_id, processing_time FROM order_processing_time;