Does anyone know of what questions to expect in SQL Interview round @ Amazon. This is for systems analyst/ data analytics role . Appreciate your comments
Given an employee table, write an SQL query that returns 5% employees to PIP
Bottom 5% for each org
Thought they increased to 15~20% since last year.
Date functions (reformatting, extracting month/day/or year), self joins, window functions (lag/lead/rank/row_number/etc), reverse cte, pivot
Thank you all!
Know how to use the rank function. Pull data for specific weekdays. The date diff function.