Question: 4. Write a query to create a yearly distribution by gender (include everything). Create a scatter with straight-line chart to show the distribution. 5. Write

4. Write a query to create a yearly distribution by gender (include everything). Create a scatter with straight-line chart to show the distribution. 5. Write a query to compare monthly sales for the year 2015. Copy and paste the results in Excel. Create a date column first. 10:59 Done customers.txt : > customerid householdid gender firstname 174596 53949999 M DANIEL 68239 49927024 M JIM 10203 20914414 F DONNA 174288 53957047 F DIONE 68099 49927024 M JIM 174257 53949983 F TRISHA 173506 53476818 M DANTE 51886 20359142 F ANTHONY 143249 20287377 F NANCY 174650 53958894 M GREG 174273 53953688 M NORMAN 58153 18321643 F C. 174633 53957466 F TERESITA 174608 53952730 M DOUGLAS 138942 36422407 M RICHARD 67973 49927024 M MIKE 174595 53949997 F MARGARET 170218 44041118 TERRY 174628 53956092 M NICK 154970 21359316 DEBORAH 167813 23137142 MALAN 63059 18185863 F BARBARA 174627 53955766 174261 53951355 F KAYE 174630 18321658 MT. 174302 53960258 M ALFRED 16268 19767590 M JOHN 174289 53957041 M SHYAM 174298 22570120 F PRISCILLA 36670 19590209 F DIANE 148876 28756344 F ROBERTA 174267 41242786 M RUSSELL 174637 53957273 F PAULA 68245 49927024 M JIM 174640 20027272 LEE 174632 53957315 F LINDA 117354 36213063 M JULIES 174593 53949990 M CHRISTOPHER 174423 53722870 M DAVID 173534 53492780 F MELISSA 70437 50134190 M RALPH 151939 22133277 F LAURIE 102698 49420354 F MARIANNE 174295 53957589 M PETER 174641 53958556 KERRY 174623 53956468 F JEANNETTE 155053 21502155 1 GORDUIN 11:00 Done orders.txt orderid customerid campaignid orderdate city state zipcode paymenttype totalprice numorderlines numunits 1002854 45978 2141 2009-10-13 00:00:00 NEWTON MA 02459 VI 190 3 3 1002855 125381 2173 2009-10-13 00:00:00 NEW ROCHELLE NY 10804 VI 10 1 1 1002856 103122 2141 2011-06-02 00:00:00 MIAMI FL 33137 AE 35.22 2 2 1002857 130980 2173 2009-10-14 00:00:00 E RUTHERFORD NJ 07073 AE 10 11 1002886 48553 2141 2010-11-19 00:00:00 BALTIMORE MD 21218 VI 101 1 1002887 106150 2173 2009-10-15 00:00:00 ROWAYTON CT 06853 AE 10 1 1 1002888 27805 2173 2009-10-15 00:00:00 INDIANAPOLIS IN 46240 VI 10 1 1 1002889 24546 2173 2009-10-15 00:00:00 PLEASANTVILLE NY 10570 MC 10 1 1 1002890 43783 2173 2009-10-15 00:00:00 EAST STROUDSBURG PA 18301 DB 29.68 2 2 1003004 15688 2173 2009-10-15 00:00:00 ROUND LAKE PARK IL 60073 DB 19.68 1 1 1003044 130970 2141 2010-11-22 00:00:00 BLOOMFIELD NJ 07003 AE 10 1 1 1003045 40048 2173 2010-11-22 00:00:00 SPRINGFIELD IL 62704 MC 10 1 1 1003046 21927 2141 2010-11-22 00:00:00 WACO TX 76710 MC 17.51 1 1003075 130971 2141 2010-11-22 00:00:00 FAIRFIELD NJ 07004 MC 59.8 1 4 1003076 7117 2141 2010-11-22 00:00:00 BROOKLYN NY 11228 AE 22.5 1 1 1003077 104566 2173 2010-11-22 00:00:00 SANTA FE NM 87505 MC 24.95 2 2 1003490 104796 2141 2011-02-15 00:00:00 LIVINGSTONNJ 07039 DB 0 1 2 1003491 39415 2141 2010-11-22 00:00:00 DELRAY BEACH FL 33445 VI 18 1 1 1003492 39734 2204 2010-11-22 00:00:00 PHOENIXVILLE PA 19460 OC 20 1 2 1003493 49066 2141 2010-11-22 00:00:00 STATEN ISLAND NY 10312 MC 34.9 3 3 1003494 103152 2141 2010-11-22 00:00:00 EAST QUOGUE NY 11942 MC 36 1 2 1003495 18815273 ZUIUMIRZZ 00:00:00 NEW

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

1. Write a query to list the firstnames and gender of customers where gender is defined properly (M or F) and first name is not an initial. Write the total count of customers that meet the criterion...

Week 2: Understanding and Exploring Assumptions You will submit one Word document, including your SPSS output. 1. Why do we care whether the assumptions required for statistical tests are met? (Tip:...

I got this big assignmnet for Quantitative methods for business i really need help Azimi, Hamida - azihy004 AH Share Comments Delete this page before submission Q-Constructions - building your future...

Drive (miles) 4 6 6 20 25 25 28 29 33 36 36 36 36 36 40 42 42 54 54 55 63 63 71 71 73 76 76 76 78 80 80 80 80 88 94 State MI SC OR MI GA CA NY TX SC TX CA MI TX OR IL FL IL FL NY OH PA OR MI MI FL NY...

Drive (miles) 36 20 88 6 71 42 76 63 36 63 38 28 55 33 40 80 86 83 4 39 25 25 54 54 81 73 29 76 78 77 42 36 71 94 6 State MI IL CA IL MI IL NY PA TX NY OR NY OH SC IL NV FL FL NY SC CA GA FL CA CA FL...

PSYC 354 HOMEWORK 3 Central Tendency and Variability When submitting this file, be sure the filename includes your full name, course and section. Example: HW3_JohnDoe_354B01 Be sure you have reviewed...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

The objective of the Homework assignment is to provide an opportunity to apply or practice the tools and techniques covered in the course and to provide an opportunity to articulate key concepts...

For this project, you will be using the StatCrunch data file Math 110 Car Models 2019 Dataset. Part 1: Data Summary (125 points) 1. There are 22 variables in the Car Models dataset, corresponding...

Two brands of tires are being tested for tread wear. To control for vehicle and driver variation, one tire of each brand is put on the front wheels of 10 cars. The cars are driven under normal...

Three males and three females are given 5 minutes to memorize a list of 25 words, and then asked to recall as many of them as possible. The three males recalled 10, 12, and 14 of the words, for an...

When selecting the maturity structure of debt securities , the minimum level of risk is achieved when the maturity of liabilities Blank _ _ _ _ _ _ the maturity of assets.

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...