TE Connectivity interview question

Write SQL query based on some requirements. Testing basics of SQL like from where having etc.