I had a 4-hour assignment requiring a full weekend (10 medium to difficult queries on an unknown 20 table database and document with business analysis for the q

I had a 4-hour assignment requiring a full weekend (10 medium to difficult queries on an unknown 20 table database and document with business analysis for the query results + additional code to extract from api and save to db with your own schema + additional queries on top of this). I also had an 1-hour where i couldn't build the provided code and had to go through maven repos and older versions of the major test component to make it work after a couple hours and then lost any motivation to write the simple exercise. I also had an honest one once, where the instructions were clear, you will need a full weekend to do it. I liked the job and i completed it, only to be rejected because they didn't like my scala syntax. Sorry, but i won't take home test again and have to gamble whether it's an actual 1h test or a full weekend one, or some random guy will spend 1 minute only to reject me.