DEV Community: Maruf Ahmed🧢

1075. Project Employees I

Maruf Ahmed🧢 — Tue, 31 Oct 2023 18:46:41 +0000

select project_id ,cast(round(sum(experience_years)*1.0/count(project_id),2) as float) as average_years from Project p join Employee e on p.employee_id = e.employee_id group by project_id

Spring Boot Relationship

Maruf Ahmed🧢 — Sat, 12 Aug 2023 18:44:33 +0000

GitHub

https://github.com/maruf409/leetcode-sql-solution.git

Maruf Ahmed🧢 — Tue, 09 Aug 2022 06:36:51 +0000

` solution-1

SELECT a.activity_date, COUNT(user_id)
FROM (
SELECT activity_date,user_id
FROM S_leetcode.Activity
GROUP BY activity_date,user_id
HAVING (activity_date >= '2019-06-28') AND (activity_date < '2019-08-25')
) AS a
GROUP BY a.activity_date

                    solution-2

select abc.activity_date,count(abc.user_id)
from (SELECT distinct activity_date,user_id FROM test.test2) as abc
group by activity_date order by 1

                    solution-3

SELECT activity_date, user_id INTO #temp
FROM S_leetcode.Activity
GROUP BY activity_date, user_id
GO
SELECT *
FROM #temp

SELECT activity_date, COUNT(activity_date)
FROM #temp
GROUP BY activity_date
`

https://www.hackerrank.com/certificates/1743011fedd6

Maruf Ahmed🧢 — Mon, 08 Aug 2022 19:49:48 +0000

https://github.com/maruf409/find-duplicate-column-in-same-table

Maruf Ahmed🧢 — Sat, 16 Jul 2022 11:10:38 +0000

my first project using Javascript ,https://github.com/maruf409/Distance-Converter-using-JS.git

Maruf Ahmed🧢 — Fri, 17 Dec 2021 14:44:33 +0000