About the Easysoft ODBC-Zoho Books Driver

SELECT * FROM Invoice

-- Which different customers do we invoice?
SELECT DISTINCT Customer_Name AS Different_Customer_Name FROM Invoice
-- How many different customers do we invoice?
SELECT COUNT(DISTINCT Customer_Name) AS Different_Customer_Total FROM Invoice

SELECT
  Invoice_Id,
  Customer_Name,
  Total
FROM
  Invoice
WHERE
  Billing_Address_Country = 'Germany'

SELECT
  Invoice_Id,
  Customer_Name,
  Total
FROM
  Invoice
WHERE
  Billing_Address_Country = 'Germany'
  OR Billing_Address_Country = 'France'

SELECT
  Invoice_Id,
  Customer_Name,
  Total
FROM
  Invoice
WHERE
  Billing_Address_Country = 'Germany'
  AND Total < 1000

cursor.execute("SELECT
  Invoice_Id,
  Customer_Name,
  Total
FROM
  Invoice
WHERE
  Billing_Address_Country = ?", ['Germany'])

SELECT
  Invoice_Id,
  Customer_Name,
  Total
FROM
  Invoice
WHERE
  NOT Billing_Address_Country = 'Germany'

SELECT
  Invoice_Id,
  Customer_Name,
  Invoice_Number
FROM
  Invoice
ORDER BY
  Invoice_Number ASC

SELECT
  Customer_Name,
  Billing_Address_City,
  Billing_Address_Country
FROM
  Invoice
ORDER BY
  (
    CASE
      WHEN Billing_Address_City IS NULL THEN Billing_Address_Country
      ELSE Billing_Address_City
    END
  );

SELECT
    COUNT(Invoice_Id) As "Number",
    Billing_Address_Country
FROM
    Invoice
GROUP BY
    Billing_Address_Country

SELECT
  COUNT(Invoice_Id) As "Number",
  Billing_Address_Country
FROM
  Invoice
GROUP BY
  Billing_Address_Country
HAVING
  COUNT(Invoice_Id) > 10;

SELECT Max(Total) FROM Invoice
SELECT Sum(Total) FROM Invoice

SELECT CAST(Total AS Char(100))FROM Invoice
SELECT {fn CONVERT(Total, SQL_CHAR)} FROM Invoice

SELECT Invoice_Id, Customer_Name FROM Invoice WHERE Total BETWEEN 10 AND 20

SELECT
  'Recurring Expense' AS Type,
  Recurrence_Name,
  Total
FROM
  Recurring_Bill
UNION
SELECT
  'Recurring Bill',
  Customer_Name,
  Total
FROM
  Recurring_Expense

SELECT
  Account_Id,
  Account_Name
FROM
  Chart_Of_Account
  INNER JOIN Bank_Account ON Bank_Account.Account_Id = Chart_Of_Account.Account_Id

SELECT Invoice_Id FROM Invoice WHERE Customer_Name LIKE 'E%'
SELECT Invoice_Id FROM Invoice WHERE Customer_Name LIKE '_asysoft'

SELECT Invoice_Id, Customer_Name, Total FROM Invoice WHERE Payment_Terms IS NULL

SELECT
  Invoice_Id,
  Customer_Name,
  Total
FROM
  Invoice
WHERE
  Billing_Address_Country = 'Germany'
  OR Billing_Address_Country = 'France'
  OR Billing_Address_Country = 'United Kingdom'

SELECT
  Invoice_Id,
  Customer_Name,
  Total
FROM
  Invoice
WHERE
  Billing_Address_Country IN ('Germany', 'France', 'United Kingdom');

SELECT Top 10 Invoice_Id, Customer_Name FROM Invoice

SELECT
  Customer_Name
FROM
  Invoice
WHERE
  EXISTS (
    SELECT
      Contact_Name
    FROM
      Contact
    WHERE
      Invoice.Customer_Id = Contact.Contact_Id
      AND Customer_Sub_Type = 'individual'
  )

INSERT INTO
  Bank_Account (
    Account_Name,
    Account_Type,
    Account_Number,
    Routing_Number,
    Currency_Code
  )
VALUES
  (
    'COOP Account',
    'bank',
    '80000009823',
    '123456789',
    'GBP'
  )

INSERT INTO
    [Zoho Books].ZOHOB.DBO.Bank_Account (
        Account_Name,
        Account_Type,
        Account_Number,
        Routing_Number,
        Currency_Code
    )
VALUES
    (
        'COOP Account',
        'bank',
        '80000009823',
        '123456789',
        'GBP'
    )

INSERT INTO
    "Bank_Account"@ZohoBooksLink (
        "Account_Name",
        "Account_Type",
        "Account_Number",
        "Routing_Number",
        "Currency_Code"
    )
VALUES
    (
        'COOP Account',
        'bank',
        '80000009823',
        '123456789',
        'GBP'
    );

$stmt = odbc_prepare($cnx, "INSERT INTO Bank_Account (Account_Name, Account_Type, Account_Number, Routing_Number, Currency_Code) VALUES (?, ?, ?, ?, ?)");
$success = odbc_execute($stmt, array('COOP Account', 'bank', '80000009823', '123456789', 'GBP'));

UPDATE Bank_Account
SET
  Account_Name = 'COOP Account'
WHERE
  Account_Id = '661294000000089005'

my $sth = $dbh->prepare('UPDATE Bank_Account SET Account_Name = \'COOP Account\' WHERE Account_Id = ?')
    or die "Can't prepare statement: $DBI::errstr";

$sth->execute('661294000000089005');

-- Delete (mark inactive) a bank account
DELETE FROM Bank_Account WHERE Account_Id = '661294000000108004'

sql = "DELETE FROM Bank_Account WHERE Account_Id = ?"
cursor.execute(sql, '661294000000097009')