Day: June 16, 2024

CISSP Preparation Review (3 Months)

สวัสดีครับ เมื่อวันที่ 15 May 2024 ผมได้มีโอกาสได้ไปสอบ Certiticate CISSP มาครับ ก็เลยอยากจะมาแชร์ประสบการณ์การเตรียมตัวสอบใน 3… Continue reading on SnoopBees » สวัสดีครับ เมื่อวันที่ 15 May 2024 ผมได้มีโอกาสได้ไปสอบ Certiticate CISSP มาครับ ก็เลยอยากจะมาแชร์ประสบการณ์การเตรียมตัวสอบใน 3…Continue reading on SnoopBees…

Users By Average Session Time

Calculate each user’s average session time. A session is defined as the time difference between a page_load and page_exit. For simplicity… Continue reading on Medium » Calculate each user’s average…

Activity Rank

Find the email activity rank for each user. Email activity rank is defined by the total number of emails sent. The user with the highest… Continue reading on Medium »…

Distances Traveled

Find the top 10 users that have traveled the greatest distance. Output their id, name and a total distance traveled. Continue reading on Medium » Find the top 10 users…

Finding User Purchases

Write a query that’ll identify returning active users. A returning active user is a user that has made a second purchase within 7 days of… Continue reading on Medium »…

New Products

You are given a table of product launches by company by year. Write a query to count the net difference between the number of products… Continue reading on Medium »…

Class Performance

You are given a table containing assignment scores of students in a class. Write a query that identifies the largest difference in total… Continue reading on Medium » You are…

Risky Projects

Identify projects that are at risk for going overbudget. A project is considered to be overbudget if the cost of all employees assigned to… Continue reading on Medium » Identify…

Expensive Projects

Given a list of projects and employees mapped to each project, calculate by the amount of project budget allocated to each employee . The… Continue reading on Medium » Given…