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
Tell me about your experience as BI.
SQL skill
What are your career goals?
Viewing 1211 - 1220 interview questions