Question d’entretien chez Amazon

Optimize SQL Queries? Find Primary Key on a Table? Lead & Lag without using those functions? De-duplicate data on SAS vs SQL?