1.Whowere the top50 retailemployeesthatworked for Smart-Buy?Report the city and state in which they worked, theirhourly_rate, total number of hours worked, and marital status, in descending order based upon the number of hours worked.

2.Several employees believe that their paychecks were calculated incorrectly. Management has asked that you produce a report that shows all employees living in Oklahoma intheexecutivedepartmentthat made more than $155,000 in the 3rdQuarter of 2018. Report theemployee_id, last name,first name,department name, total gross salary. This report should be in alphabetical order from A - Z.

3.Smart-Buy wants to understandhow many periodstheir seasonal workers worked during the busy season (4thquarter).

4.Ifsmart-buywants to relocate headquarters, where should they relocate the headquarters?HINT:It is easier touse at least 2 queries to answer this question.Take into consideration where the employees associated with headquarters (for example:accountants, IT workers,executives, and possibly others) currently live.Also consider the location of our most lucrative stores.

Figure out how to provide a heatmap of the location of the most lucrative stores, however you can be creative and use other tools if you like.

Sort & Filter Records addresses X calendar X departments X employee_info X ID period store id store_reven - Click to Add 10/1/ 2017 1000 435887.17 10/15/2017 1000 296327.95 B 11/1/2017 1000 630305.28 4 11/15/2017 1000 990760.44 12/1/2017 1000 684759.63 12/15/2017 1000 898176.12 7 1/1/2018 1000 964254.1 8 1/15/2018 1000 277307.82 19 2/1/2018 1000 173901.5 10 2/15/2018 1000 981765.66 11 3/1/2018 1000 218546.91 12 3/15/2018 1000 955087.28 13 4/1/ 2018 1000 409176.51 14 4/15/2018 1000 175907.08 15 5/1/2018 1000 731308.61 16 5/15/2018 1000 683178.09 17 6/1/2018 1000 84088739 18 6/15/2018 LOOO 871268. 72 19 7/1/2018 10OO 1009 154. 38 20 7/15/2018 897191.12 21 8/1/2018 $20652.92 212 13/15/2018 785782.84 2B 9/1/ 2018 1090 689675.02 24 19/15/2018 Record: 19 1 of 25080 . Search2 4 Ascending Selection New S Al Descending Advanced - Save Filter Refresh ainter Remove Sort Toggle Filter X Delet Sort & Filter Rec calendar x departments X