Pergunta de entrevista da empresa Gracenote

Round 2; SQL Query: Given table of events with event_type, event_time and event_crowd. Find largest and second largest crowd value for all event types and provide their difference.

Resposta da entrevista

Sigiloso

1 de jan. de 2019

It was easy query however the query editor was available in postgrace and sqllite and i am sql server guy. wrote query using simple sql statement.