Rewrite my working SQL Script

User Generated

pbeznpxvaarl

Programming

Question Description

I am a weak SQL programmer, but this script does work. It is a very simple database of resumes. Using brute force of lots of temp tables and repeated joins, it runs very slowly. MS SQL 2008 I need you to rewrite it elegantly to produce the same result for larger tables. I expect this to be a 1-3 hour job for an experienced SQL guru. I expect to paste and run your code with little or no tweaking. Need this on Monday Aug 26.SQL Script 

Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Explanation & Answer

hfzna9 (20)
UCLA

Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4