Project 1

Project-1

Task 3:

1. SELECT * FROM customers WHERE city='Banglore';

2. ALTER TABLE products RENAME COLUMNS product TO prod_;

3. SELECT COUNT(customer_id), purchased FROM customers GROUP BY purchased HAVING COUNT(customer_id)<=1;

4. SELECT * FROM Customers WHERE cust_name LIKE 'A%A';