Aws setup and basic data filtering

1. Create a free account in AWS account, create S3 service (Cloud Object Storage – Amazon S3 – Amazon Web Services )and store the data in a bucket (name the bucket as yourname_demo). 2. Create AWS Postgres RDS database service (Amazon RDS | Cloud Relational Database | Amazon Web Services), name it yourname_demo_rds and load the data from the S3 bucket Activity -2 1. Download pgadmin4 ( Download ([login to view URL])) to your local machine 2. Connect the postgres db you have created - yourname_demo_rds 3. Run the sql query to retrieve following information from the db: a. How many unique ProductID are available b. How many unique ProductType are available c. Filter the db for OutletSize = Small and create a child table and name it outlet_small d. Filter the db for OutletSize = Medium and create a child table name it outlet_medium e. Filter the db for OutletSize = High and create a child table name it outlet_high