Amazon For Business Analyst interview questions

I had applied for Business Analyst as an MBA graduate . The first round I had was technical where the interviewer asked me sql questions , he gave me real time scenarios and asked me to write queries based on date function. First thing in given limited time you are supposed to understand the query and then writing it with correct syntax takes time and people freak out because of the time constraint. It would be good if they check out SQL knowledge and not syntax query because even in real time scenarios people check the syntax online. Knowing approach and what to use in SQL would have be better than writing the query in 2 min