Project 1

Task 1:

Task 2:

please find the attachment

Task 3:

1.

select * from users order by userCity;

2.

alter table product
rename column productId to prod_productId,
rename column sellerId to prod_sellerId,
rename column productName to prod_productName,
rename column productSizeAvailable to prod_productSizeAvailable,
rename column quantityAvailable to prod_quantityAvailable,
rename column productPrice to prod_productPrice,
rename column productWeight to prod_productWeight,
rename column currentDiscount to prod_currentDiscount,
rename column productCategoryId to prod_productCategoryId,
rename column productImage to prod_productImage,
rename column productLocation to prod_productLocation,
rename column productDescription to prod_productDescription;

3.

select * from users inner join orders on orders.customerId = users.userId;

4.

select * from users inner join orders on orders.customerId = users.userId where orders.orderQuantity > 1 and orders.customerId like 'A%' and '%A';

5.

select * from users inner join orders on orders.customerId = users.userId inner join prodHistory on orders.productId=prodHistory.productId where orders.orderStatus = 'delivered' and orders.orderAmount > 10000 and prodHistory.prodPurchByCust > 1;