QuickBooks Query for Unit Sales Report

you can use QODBC  to query quickbooks from Excel

and this link shows how you can get a refreshable connection with quickbook

I have QODBC and I also use Excel to query data.

However, my knowledge is limited in the SQL query. I know things like SELECT * FROM TABLE WHERE X.

What would the query be? I've figured out the QODBC and Excel Connection part.

if you so not know know how to establish connect with QB then see this step by step screenshots this

SELECT * FROM Customers
WHERE Country='Mexico';

you can learn in detail the SQL statements from  here

Okay, I know how to establish that connection.

I have read that link you have sent me.

What I don't know how to do, is write the actual query that will show me Items, Units Sold of those Items in 2015.

Can you give me the words from what table which column criteria and which column you want to sum

Then I will write the sql statement for you

No, that actually looks perfect. Let me try that.