Amazon Interview Question
Development Support Engineersquery for todays order:
select customerid, orderid, orderdate from customer where orderdate=TO_DATE(31-DEC-2010,'DD-MON-YYY');
query for past 30 days
select customerid, orderid, orderdate from customer where orderdate > TO_DATE(31-DEC-2010,'DD-MON-YYY') AND orederdate <=TO_DATE(31-DEC-2010,'DD-MON-YYY') - 30;
SELECT TOP 1 orderdate, count(*) from customerorder where orderdate between getdate()-30 and getdate() group by orderdate order by count(*) desc
- Anonymous December 28, 2010