William Ong William9923

Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.

Discussion on reddit.

Python 2.x

$ python -m SimpleHTTPServer 8000

	Last update: 11/03/2024 18:28
	!Completed: https://mega.nz/folder/sMcCXKpa#_R-M2Cqh9NYbFWWVWVAmxw
	!EPUB: https://mega.nz/folder/5AE2DTKS#-u5vZ1LauFo4vRDiAvFQIw
	!PDF: https://mega.nz/folder/ER1HXJZT#AnftN521aESOeisBWk_tMw
	!Yaoi/37C: https://mega.nz/folder/8A0RyZIS#x4N8tGqddmDHMMbCy1L0qA
	!Yaoi/A Kiss and a Pair of Handcuffs: https://mega.nz/folder/0V9zTQ6J#TnF--X0XuXuKr_lmIqTOxA
	!Yaoi/Ai no Kusabi: https://mega.nz/folder/5FUhmLyA#p_iCdky89s6sTHJNAHXMDQ
	!Yaoi/Ai Shika Iranee yo: https://mega.nz/folder/cR9FRADS#8Byg_qCw_mQ1VIGEFCc4KA
	!Yaoi/All My Loving: https://mega.nz/folder/Ud80ATRK#BFzuo5vhxZx1uYtZlhwbVw
	!Yaoi/Amazing Grace: https://mega.nz/folder/FcFW2bRC#vxpnv6Kq4MwPYOsUI1353g

	select user_name , customer_zip_code , customer_city , customer_state
	from (
	SELECT
	DISTINCT *,
	RANK() over(
	PARTITION BY user_name
	ORDER BY customer_zip_code DESC, customer_state DESC , customer_city DESC
	) as rank
	FROM
	live.user u

	-- Notes : Inserting updated data on product dimenstion table
	insert into staging.dim_product (
	product_id,
	product_category,
	product_name_length,
	product_description_length,
	product_photos_qty,
	product_weight_g,
	product_length_cm,
	product_height_cm,

+insert into staging.dim_product (
+	product_id,
+	product_category,
+    product_name_length,
+    product_description_length,
+    product_photos_qty,
+    product_weight_g,
+    product_length_cm,
+    product_height_cm,
+    product_width_cm,

+-- Fact table
+with stg_snapshot_user as (
+	select distinct
+		user_name,
+		count(order_id) as num_order
+	from live."order"
+    where order_status is not null and order_status not in ('canceled', 'unavailable')
+	group by user_name
+), stg_snapshot_spending as (
+	select distinct

	COPY live.order (order_id, user_name, order_status, order_date, order_approved_date, pickup_date, delivered_date, estimated_time_delivery)
	FROM 'C:\Users\William\Documents\DataScience\blibli\e-commerce-datsci-proj\data\raw\order_dataset.csv'
	DELIMITER ','
	CSV HEADER;

	-- and so on