task
problem
solution
queries
how many customers does clothes inc. have
how many purchases haven been made?
how much money has been made per month from product sales
campaigns
sms campaigns
marketing campaign
write sql
create erd
mamp
test sql
tables
cardinality
phpmyadmin
primary, foreign keys
customer contact info
product info
customer purchases
catergory
database needed
excel spreadsheet
customer name
address details
phone numbers
all customers
customers purchased clothing for men, women, kids
customers purchased clothing for kids
customers who haven't purchased clothing for kids
privacy act
What are the customers names and address details for all customers?
What are the customers names and address details for customers who have purchased clothing for men?
What are the customers names and address details for customers who have purchased clothing for women?
What are the customers names and address details for customers who have purchased clothing for kids?
What are the customers name and mobile phone numbers for customers who have purchased clothing for kids?
What are the customer’s name and mobile phone numbers for customers who haven’t purchased clothing for kids?
What are the most commonly bought items from Clothes Inc.?
How many sales have been made per month?
What is the most popular category of product bought?
unique ids
csv
relevant principles