For all titles, show: Total sales amount for 2011 and 2010 Total quantity sold for 2011 and 2010 Flag titles with no sales in 2011 (for deprecation) 2. Given a transactions table with dates and statuses (COMPLETE, REFUNDED, CANCELLED, etc.), write a query to return the trailing revenue for each date.
Tell me about yourself and why amazon!?
Take a sql skills test
Q1 How many units were sold yesterday? Output: order_day | units
How would you handle a case where the report is running slowly.
2. What is diff between union and union all
SQL question based on CTE, Window Functions. Solve a bunch of SQL questions on Leet code to be able to smoothly answer these questions
Why PA?
Tell me about your experience as BI.
How would you design a packaged solution for customer needs
Viewing 1211 - 1220 interview questions