The Data of industrial production of electric and gas utilities in the United States were recorded from the years 1985–2018. This data measures the real output of all relevant establishments located in the United States, regardless of their ownership, but not those located in U.S. territories. …

This is one of SQL project in DQLab. There are four tables: ms_pelanggan, ms_produk, tr_penjualan, tr_penjualan_detail with fields and data type written below.

  1. Show list of products from ms_produk table which has price between 50000 to 150000. Column that must be displayed: no_urut, kode_produk, nama_produk, and harga.
SELECT no_urut, kode_produk…

Problem Definition

During the Covid-19 pandemic in 2020, total sales in e-commerce increased by 37%. Due to increasingly fierce competition between competitors, you and your Product Manager discussed how to stay afloat and compete in e-commerce industry. …

Dana Annisa Riefina

Excited to learn more in data field, sometimes read, mostly watch movies.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store