# Hello, world!
print("Hello, World!")

# Variables and f-strings
name = "Raman"
age  = 28
print(f"My name is {name}, age {age}.")

# A simple loop
for i in range(3):
    print(f"Count: {i}")

-- Find top customers by revenue
SELECT c.name,
       SUM(o.amount) AS total
FROM customers c
JOIN orders o
  ON c.id = o.customer_id
GROUP BY c.name
ORDER BY total DESC
LIMIT 5;

public class HelloWorld {
    public static void main(String[] args) {
        String name = "Raman";
        int age = 28;
        System.out.println(
            "Hello, " + name + "!"
        );
    }
}

import anthropic

client = anthropic.Anthropic()

message = client.messages.create(
    model="claude-sonnet-4-5",
    max_tokens=1024,
    system="You are a data engineering expert.",
    messages=[{"role":"user",
               "content":"Design a star schema for retail."}]
)
print(message.content[0].text)

-- Star Schema: Fact + Dimensions
SELECT
  d.customer_name,
  t.month,
  p.product_name,
  SUM(f.revenue) AS total
FROM   fact_sales f
JOIN   dim_customer d ON f.customer_key = d.key
JOIN   dim_time     t ON f.time_key     = t.key
JOIN   dim_product  p ON f.product_key  = p.key
GROUP BY d.customer_name, t.month, p.product_name;

-- ERWIN Forward Engineered DDL
CREATE TABLE customer (
  customer_id BIGINT GENERATED ALWAYS
              AS IDENTITY,
  first_name  VARCHAR(50)  NOT NULL,
  email       VARCHAR(254) UNIQUE NOT NULL,
  created_at  TIMESTAMPTZ  DEFAULT NOW(),
  CONSTRAINT pk_customer
    PRIMARY KEY (customer_id)
);