Intentive Data Science Class by @myskill.id

Data

In Ruby’s Company, we sales fruits.

Firstly we would like to check our sales database as below:

Challenge

  1. By using data sales,

  1. Show fruits sales report at store 3,4,5 where fruits price per kg are above 11000

  2. Show fruits sales after Ied Fitr day 2022

  1. Show fruits sales for Mangga and Jeruk in all store except store 1,6,7
  1. By using employees_data,
  1. Show employees data and their salaries on 2021
  2. Show employees name that work at store 3,4,7 and have salaries above $5000 on 2022