Analysis Given the new make-up of the organization Smart-Buy wants to understand some specifics of the new employee base. Below are a few questions that will aid in that endeavor. 1. Several employees believe that their paychecks were calculated incorrectly. Management has asked that you produce a report that shows all employees living in Oklahoma in the accounting department in the 3rd Quarter of 2018. Report the employee_id] last name, department name, total gross salary. This report should be in alphabetical order from A - Z. 2. What were the top 75 paid seasonal retail employees that worked for Smart-Buy in December of 2018? Report the city and state in which they worked, their hourly rate, total number of hours worked, and marital status, in descending order based upon the number of hours worked. 3. Smart-Buy wants to understand if most of their seasonal workers worked more than 4 periods during the busy season (4th quarter). List (by employee id and last name) the number of periods worked and the total gross pay for seasonal retail workers in the 4th quarter of 2017 and the 4th quarter of 2018. If the results of this query are more than 100 records, only report the first 10 in your write-up. 4. If smart-buy wants to relocate headquarters, where should they do this? Please use at least 2 queries to answer this question. Take into consideration where the employees that work jobs that would be associated with headquarters (for example: accountants, IT workers, executives, and possibly others) currently live. Also consider the location of our most lucrative stores.

write queries for each question

Given the new make-up of the organization Smart-Buy wants to understand some specifics of the new employee base. Below are a few questions that will aid in that endeavor. 1. Several employees believe that their paychecks were calculated incorrectly. Management has asked that you produce a report that shows all employees living in Oklahoma in the accounting department in the 3rd Quarter of 2018. Report the employee_id I last name, department name, total gross salary. This report should be in alphabetical order from AZ. 2. What were the top 75 paid seasonal retail employees that worked for Smart-Buy in December of 2018 ? Report the city and state in which they worked, their hourly rate, total number of hours worked, and marital status, in descending order based upon the number of hours worked. 3. Smart-Buy wants to understand if most of their seasonal workers worked more than 4 periods during the busy season ( 4th quarter). List (by employee id and last name) the number of periods worked and the total gross pay for seasonal retail workers in the 4th quarter of 2017 and the 4th quarter of 2018. If the results of this query are more than 100 records, only report the first 10 in your write-up. 4. If smart-buy wants to relocate headquarters, where should they do this? Please use at least 2 queries to answer this question. Take into consideration where the employees that work jobs that would be associated with headquarters (for example: accountants, IT workers, executives, and possibly others) currently live. Also consider the location of our most lucrative stores