Zend certified PHP/Magento developer

How do I write an SQL query for Orders by SKU with Shipiping to California between X and Y dates

I can’t find a way to generate a table or report that will get me

Orders by SKU with Shipping to California between X and Y dates.

Anyone ever tackle this without an extension.

Thanks so much 🙂