วีดีโอ

Where is dataset file

Thanks for this amazing course

My approach : with cte as ( select *, max(salary) over(partition by company_id) as max_salary from salaries) select company_id, employee_id, employee_name, salary, case when max_salary <1000 then salary when max_salary >=1000 and max_salary<=10000 then salary - 0.24*salary else salary - 0.49*salary end as new_salary from cte;

Hi , I want to join discord community but it's showing invalid invitation . please share correct invite link

Excellent content! learned a lot being a newbie here. I like the postgresql functions String_To_Array() in combination with UNNEST(). It made the complex parsing of delimited text field a breeze. You just got a new subscriber here because of this wonderful tutorial. Thanks for all your efforts.

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems th-cam.com/video/J9qFIAH788Q/w-d-xo.html 🐍 All Python Projects: Python ETL - Data Cleaning Project th-cam.com/video/uDQO9xOg4xg/w-d-xo.html

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems th-cam.com/video/J9qFIAH788Q/w-d-xo.html 🐍 All Python Projects: Python ETL - Data Cleaning Project th-cam.com/video/uDQO9xOg4xg/w-d-xo.html

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems th-cam.com/video/J9qFIAH788Q/w-d-xo.html 🐍 All Python Projects: Python ETL - Data Cleaning Project th-cam.com/video/uDQO9xOg4xg/w-d-xo.html

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems th-cam.com/video/J9qFIAH788Q/w-d-xo.html 🐍 All Python Projects: Python ETL - Data Cleaning Project th-cam.com/video/uDQO9xOg4xg/w-d-xo.html

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems th-cam.com/video/J9qFIAH788Q/w-d-xo.html 🐍 All Python Projects: Python ETL - Data Cleaning Project th-cam.com/video/uDQO9xOg4xg/w-d-xo.html

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems th-cam.com/video/J9qFIAH788Q/w-d-xo.html 🐍 All Python Projects: Python ETL - Data Cleaning Project th-cam.com/video/uDQO9xOg4xg/w-d-xo.html

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems th-cam.com/video/J9qFIAH788Q/w-d-xo.html 🐍 All Python Projects: Python ETL - Data Cleaning Project th-cam.com/video/uDQO9xOg4xg/w-d-xo.html

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems th-cam.com/video/J9qFIAH788Q/w-d-xo.html 🐍 All Python Projects: Python ETL - Data Cleaning Project th-cam.com/video/uDQO9xOg4xg/w-d-xo.html

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems th-cam.com/video/J9qFIAH788Q/w-d-xo.html 🐍 All Python Projects: Python ETL - Data Cleaning Project th-cam.com/video/uDQO9xOg4xg/w-d-xo.html

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems th-cam.com/video/J9qFIAH788Q/w-d-xo.html 🐍 All Python Projects: Python ETL - Data Cleaning Project th-cam.com/video/uDQO9xOg4xg/w-d-xo.html

🎯 Get Latest SQL Guided Project (1M sales records) 🎯topmate.io/zero_analyst/1237072 🎯 Get Latest End to End Advanced SQL Project (Amazon)+ 70 Business Problems th-cam.com/video/J9qFIAH788Q/w-d-xo.html 🐍 All Python Projects: Python ETL - Data Cleaning Project th-cam.com/video/uDQO9xOg4xg/w-d-xo.html

WITH ranked_rides AS (SELECT d.city AS city_name, d.driver_id, d.driver_name, COUNT(r.ride_id) AS total_completed_rides, AVG(r.rating) AS avg_rating, DENSE_RANK() OVER(PARTITION BY d.city ORDER BY AVG(r.rating) DESC) AS rnk FROM Rides r INNER JOIN Drivers d ON d.driver_id = r.driver_id WHERE r.end_time IS NOT NULL AND r.start_time >= current_date() - interval 3 month GROUP BY 1,2,3 HAVING COUNT(r.ride_id) >= 5 ) SELECT city_name, driver_name, total_completed_rides, avg_rating FROM ranked_rides WHERE rnk =1;

📂 Get this dataset and complete project for free! github.com/najirh/Walmart_SQL_Python

Great sir

Helpful project

Keep Going sir 🙌

SELECT actor_id,director_id, count(actor_id) as act_count,count(director_id) as dir_count FROM ActorDirector group by actor_id,director_id having count(director_id) >= 3 and count(actor_id) >=3

select count(*) as total_users, SUM(CASE WHEN status = 'Open' THEN 1 Else 0 END) as active_users, Round(SUM(CASE WHEN status = 'Open' and country = 'USA' THEN 1 Else 0 END)/ SUM(CASE WHEN status = 'Open' THEN 1 Else 0 END),2) * 100 as active_user_share_for_US from fb_active_users;

Bro your discord link not working 😔

Bro please reorder your playlist from Lecture 1 to the last lecture. It's currently in last to first order. Thank you

with cte as ( SELECT city, driver_name, COUNT(CASE WHEN end_time IS NOT NULL THEN 1 END) AS cnt, AVG(rating) AS avg_rating FROM drivers D JOIN rides R ON D.driver_id = R.driver_id WHERE EXTRACT(DAY FROM (CURRENT_DATE - start_time)) <= 90 GROUP BY city, driver_name HAVING COUNT(*) >= 5 order by city ) select * from ( select *, rank() over(partition by city order by avg_rating desc) as rnk from cte ) where rnk = 1

select actor_id,director_id FROM ActorDirector GROUP BY actor_id,director_id HAVING COUNT(timestamp)>=3;

Task: Select * FROM (select market_place, seller_id, sum(total_sales),Dense_rank() over(partition by market_place order by sum(total_sales) desc) as drk from sales_data where month(month) = 1 Group by market_place, seller_id)t where drk <= 3

Nice Video! Im learning alot, TYVM. However, I have a question -Why not import directly the csv dataset without needing to define the table columns? Could it be done this way?

How do i buy it from nepal?

Most interesting

WITH cte AS ( SELECT Drivers.driver_name, city, start_time, end_time, rating FROM Drivers JOIN Rides ON Drivers.driver_id = Rides.driver_id WHERE (YEAR(start_time) = YEAR(NOW()) AND MONTH(start_time) BETWEEN MONTH(NOW()) - 3 AND MONTH(NOW())) OR (YEAR(start_time) = YEAR(NOW()) - 1 AND MONTH(start_time) > MONTH(NOW()) - 3) ), cte2 AS ( SELECT driver_name, COUNT(*) AS c1 FROM cte GROUP BY driver_name HAVING COUNT(*) >= 5 ), cte3 AS ( SELECT cte.* FROM cte JOIN cte2 ON cte.driver_name = cte2.driver_name ), cte4 AS ( SELECT city, driver_name, COUNT(*) AS c1, AVG(rating) AS avg_rat FROM cte3 GROUP BY city, driver_name ) SELECT city, driver_name, c1, avg_rat FROM ( SELECT cte4.*, DENSE_RANK() OVER (PARTITION BY city ORDER BY avg_rat DESC) AS x1 FROM cte4 ) AS es WHERE x1 = 1;

superb explanation. also, very helpful sql bot. Thank you

Task: Select hotel_name,payment_type, count(*) as total_bookings from bookings where weekday(booking_date) IN (5,6) Group by hotel_name, payment_type Order by total_bookings DESC

Select hotel_name, count(*) as total_bookings from bookings where weekday(booking_date) IN (5,6) Group by hotel_name Order by total_bookings DESC

🔥

can I build this project using snowflake?

Great video!🎉 If there would be timestamp in the videos then it would be really helpful.