Question: 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

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 here. You can calculate the total count anyway, you want. 2. Write a query to provide information on Gender by State for the top 10 states. The total number of customers defines top 10. Gender should include the unknown gender as well. Copy and paste the results in Excel. Create an appropriate chart, which is sorted/ordered properly. 3. Write a query to prove that there is a gender difference in customer purchase patterns. In other words, Do Male buy more than Female (in terms of numunits and total price). Copy and paste the results in Excel. Show the results with a chart and answer the question. (Hint: You can create a dual axis chart with Totalprice on primary and NumUnits on secondary axis using a combo chart. 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. 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 here. You can calculate the total count anyway, you want. 2. Write a query to provide information on Gender by State for the top 10 states. The total number of customers defines top 10. Gender should include the unknown gender as well. Copy and paste the results in Excel. Create an appropriate chart, which is sorted/ordered properly. 3. Write a query to prove that there is a gender difference in customer purchase patterns. In other words, Do Male buy more than Female (in terms of numunits and total price). Copy and paste the results in Excel. Show the results with a chart and answer the question. (Hint: You can create a dual axis chart with Totalprice on primary and NumUnits on secondary axis using a combo chart. 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

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!

Compte, Incorporated (a U.S.-based company), establishes a subsidiary in Croatia on January 1, 2023. The following account balances for the year ending December 31, 2024, are stated in kuna (K), the...

Hello, below I have a database which I've created below and also all of the foreign key constraints. I need help with two things: One, I can't seem to see the logic on which tables to drop first and...

Could someone help me with this please. I dont know anything about it :( I suck at things like that. For maintaining its product and sales information Computer Wzadsloc contains the following three...

CREATE TABLE TJobs ( intJobID INTEGER NOT NULL , intCustomerID INTEGER NOT NULL , intStatusID INTEGER NOT NULL , intServiceID INTEGER NOT NULL , dtmStartDate DATE NOT NULL , dtmEndDate DATE NOT NULL...

IT-111 Database Design and SQL 1 FINAL PROJECT Instructions: You are to create a database, primary keys, foreign keys, indexes, inserts, updates, views, and other SQL Select statements based on the...

-- SECTION 1: Single-Table SQL Queries --******************************************* -- 1. Write a query to display customers last names, first names, and email addresses. -- Sort your results by...

--******************************************* -- SECTION 1: Single-Table SQL Queries -- --******************************************* -- 1. Write a query to display customers last names, first names,...

#create and use the TreasureHunter database CREATE DATABASE IF NOT EXISTS `treasurehunters`; USE `treasurehunters`; #create and populate the badge table, which has descriptions of all the types of...

gfhfpostgreSQL - PART 1 : Creating a table using the following attributes: sale _ date,sale _ year,sale _ month,age,gender,country,state,category,sub _ category,quantity,unit _ cost , unit _...

postgreSQL - PART 1 : Creating a table using the following attributes: sale _ date,sale _ year,sale _ month,age,gender,country,state,category,sub _ category,quantity,unit _ cost , unit _...

When do customers purchase the firm's products in relation to Federation Artisan Chocolate (federationchocolate.com) How does purchase behavior vary based on different promotional events...

Molex Berhad is a company that manufactures health products. The following is information related to production costs. Variable cost per unit Direct raw materials Direct labor Factory overhead...

A 1 3 - year - old male was riding a altered vehicle when he drove into a wire fan is sitting on the ground with a towel over his lower face. He has up to draw fracture. What is your primary concern?

What is an example of constructive feedback? provide reference