Project 1

Project 1.

Task1 2.

Task 3.

1. SELECT * FROM Customers
ORDER BY Country DESC;

2. ALTER TABLE table_name

RENAME COLUMN old_name TO new_name;

3. SELECT orders.ord_no, customer.customer.name

FROM orders, customer

WHERE orders.customer_id=customer.customer_id;

4. SELECT customer.name(startA endA)

WHERE purc_prod>1;

5. SELECT* From orders a WHERE purc_amt >10000

SELECT AVG(purcg_amt) FROM orders b

WHERE b.customer_id = a.customer_id;

6. ALTER TABLE table_name

ADD column_name datatype;