How to Port SQL Queries Between Databases Using Gemini

SQL

SELECT 
    c.CustomerID,
    c.FirstName || ' ' || c.LastName AS FullName,   -- Change 1: Pipes for concat
    COUNT(o.OrderID) AS TotalOrders,
    SUM(od.Quantity * p.Price) AS TotalSpent,
    EXTRACT(YEAR FROM o.OrderDate) AS OrderYear     -- Change 2: Extract Year
FROM Customers c
JOIN Orders o ON c.CustomerID = o.CustomerID
JOIN OrderDetails od ON o.OrderID = od.OrderID
LEFT JOIN Products p ON od.ProductID = p.ProductID 
WHERE 
    p.Category = 'Electronics' 
    -- Change 3: ANSI Date Literals (Safest way to handle dates)
    AND o.OrderDate BETWEEN DATE '2023-01-01' AND DATE '2023-12-31' 
GROUP BY 
    c.CustomerID, 
    c.FirstName, 
    c.LastName, 
    EXTRACT(YEAR FROM o.OrderDate)
HAVING 
    SUM(od.Quantity * p.Price) > 500
ORDER BY 
    TotalSpent DESC
FETCH FIRST 5 ROWS ONLY;                            -- Change 4: Limit syntax

--------------

 Prompt: "Act as a Senior Database Administrator proficient in both Oracle and SQL Server (T-SQL).

Please convert the following Oracle SQL query to a SQL Server compatible query.

Requirements:

1. After the code block, list the specific changes you made and explain why.

Here is the Oracle Query:

SQL

[PASTE YOUR ORACLE QUERY HERE]

```"

--------------------------