Project 1

1. CREATE coupon code(

CREATE Percentage per coupon(

CREATE Shipments invoice user

CREATE wishlist replacement,different order status,product,customer, orders,seller

coupon code,percentage coupon, shipments invoice user, wishlist replacement,different order status,customers,order,seller Primary keys,

Name varchar(12) NOT NULL,

shipments varchar(12),

Products decimal(12,8)

);

Query OK,) 0 Rows affected(gender)

Query OK, order seller(3.08 sec)

2. SELECT a.ord_no,a.purch_amt,

b.cust_name,b.city

FROM orders a,customer b

WHERE a.customer_id=b.customer_id

AND a.purch_amt BETWEEN 500 AND 2000;

2.ALTER TABLE table_name

ADD column_ datatype;

ALTER TABLE users

ADD id_number TEXT;

ALTER TABLE USERS

ALTER TABLE table _name

RENAME column old_name to new_name;

ALTER TABLE userrs

RENAME COLUMN id TO user_id;

3. SELECT customer_id MAX(Purcgh_amt)

FROM orders

WHERE customer_id BETWEEN 3003 AND 3007

GROUP BY customer_id

HAVING MAX(purch_amt)>1000;

4. SELECT count (item_id) order_count,customer_id, customer_name

FROM customers

INNER JOIN Orders ON Customers.customer_id= orders.customer_id

INNER JOIN Order_details ON Orders.order_id= Order_details.order_id

GROUP BY customer_id, customer_name

Count(item_id)>1

5.SELECT a.cust_name,a.city, b.ord_no,

b.ord_date,b.purch_amt AS "order amount"

FROM customer a

LEFT OUTER JOIN Orders b

ON a.customer_id=b.customer_id

Order by ord_date;

6. CREATE TABLE persons(

PersonID int,

Last name varchar(255),

first name varchar(255),

Address varchar(255),

city varchar(255)

);

INSERT INTO customers

(customer name,city,country)

VALUES(Cardinal,'stavenger'', 'norway');

1. CATEGORIES SHOPPING ORDER

CATEGORY ID(PK)

Category type

Category-name

category-type