Real Consulting Database Developer interview questions

I believe it was very difficult and unrealistic. They asked me to write a small SQL program in a few minutes with a database I only had seconds to view and no notes or internet search was permitted. I don't believe that in a real world environment I could not just google a random command that I could not remember at the time.