Question About Coding In Industry

Hi Andrew!
Thanks for reaching out.

It's all relevant - the "fetch time", as it is called in MySQL, varies upon the size of the computer's RAM memory, the server containing the database and how many people are using it at that moment, the characteristics of the server and machine you are working with, etc. 

In the video in the course you see a situation in which there is only one computer attached to the server (the latter being local), so the fetch time is relatively low compared to other work scenarios. Of course, if the machines at the company you are working at are quick and well set up, the fetch time will not be much different for a database of the size of employees.sql.

Hope this helps.
Best,
Martin

Correct me if I'm wrong, Andrew, but I think he didn't mean how long it would take to fetch the queried output, but rather how long it should take the data analyst to write the query.

Hi Anna-Sophie!

Thanks for reaching out.

Please excuse me for misunderstanding. Naturally, I'd say it depends on the analyst's experience, as well as their knowledge on the nitty gritties of the database. Once you are technically advanced enough to work autonomously with subqueries, it might take you no longer than half an hour; or a little longer if you are unsure of how the database relations have been stipulated (in which case you'd normally run several queries aside, to ensure namely the database organisation). 

Hope this helps.
Best,
Martin