Queries

Samantha is a small e-commerce owner who would like a database to keep track of her clients and see what her product is most profitable. She also wants to keep track of the supplier so she can know what material is in high demand.

2- Stakeholder Analysis

Owner: She has access to all the website settings. She can make all the changes that the business needs to grow.

Supplier: Provides the appropriate material to make the jewelry.

Customer: Needs access to the website and the ability to place an order.

3-Solution Objectives

Digital tracking of supplier

Track the best customer

Find out the best product on the site

Improve price update

Improve customer service

Which customers bought more gold charms than silver ones?

Delete customers from the new table in the prior exercise who have spent more than $100 in the past year.

Calculation; Add up, how much have Samantha made of selling only the neckless

Create at least 2 views, (make a question for this query)