How to query database UCCX to create customize report

[quytx]

Hi every one, i am creating customize report on UCCX. but i am cant create on query on UCCX database. Can you help me a query simple ?

This is my query but allway fail

SELECT first 1000
*
FROM
db_cra:contactcalldetail;
where callednumber = 'XXXX' 

or 

SELECT first 1000
*
FROM
db_cra:contactcalldetail;
where callednumber = "XXXX"