This query was in a version of SQL I had not used for about 8 years and I was not applying to be a database engineer, but a web developer. You will be tested at the edges of your expertise.