sql homework 1

1.What is the CURRENT email address for the person with the last name of “Trenary”? (5 points)

2.How many products are there? (5 points)

3.How many products cost more than $100? (5 points)

4.How much do we sell gloves for? (5 points)

5.Which order was the largest? (7.5 points)

6.Which customer(s) have purchased the most size medium socks (not $ amount)? Must include their name. (10 points)

7.Who manages the employee “Dan Wilson”? The result set should the manager’s EmployeeID, name (first & last combined into a single column), job title, and when they were hired (MM-DD-YYYY). (10 points)

8.List each sales person’s name (first & last), Job Title and total number of customers that each sales person has sold to. Sort by the most number of customers first. (10 points)
Bonus – who has the most customers in each territory? (This should be a single query that sorts by territory. (5 points)
DOUBLE Bonus – which Sales Manager has the most sales? (5 points)

9.Which product has had its price change the fewest times? (7.5 points)

10.List, for each product (ProductID and Product Name), the % of profit made when selling it (10 least profitable products). Are there any products we should consider dropping? Why? (15 points) Hint: make sure you know how to calculate profit!

Plot the previous data (Q10) for the clothing category, with the x-axis as the % profit and the y-axis as the clothing name. (10 points)

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational