SQL Describe Table

Why SQL Describe Table is important

-- Example table (replace with your actual table)
CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    OrderDate DATE,
    OrderAmount DECIMAL(10, 2)
);

INSERT INTO Orders (OrderID, OrderDate, OrderAmount)
VALUES
(1, '2023-10-26', 100.50),
(2, '2023-11-15', 250.00),
(3, '2023-10-10', 150.75);

-- Extract the year from the OrderDate
SELECT OrderID, EXTRACT(YEAR FROM OrderDate) AS OrderYear
FROM Orders;

-- Calculate the difference between two dates (in days)
SELECT OrderID, OrderDate, (JULIANDAY('2023-11-30') - JULIANDAY(OrderDate)) AS DaysSinceOctober
FROM Orders
WHERE EXTRACT(MONTH FROM OrderDate) = 10;

-- Format the date in a specific way
SELECT OrderID, TO_CHAR(OrderDate, 'Month DD, YYYY') AS OrderDateFormatted
FROM Orders;

-- Find orders placed in October 2023
SELECT *
FROM Orders
WHERE OrderDate BETWEEN '2023-10-01' AND '2023-10-31';