You work for a CPA firm. Their database tables are shown bel…
You work for a CPA firm. Their database tables are shown below. Please explain the steps and specific joins required to determine the following: 1. What is the process to determine total billing by employee level? 2. What is the process to determine the total hours billed by service type? Please note: In your answer, please clearly identify the key fields, the type of join, and specify any calculation or aggregation used for your final results.
Read Details