Tech for good

[Stratascratch/SQL] Successfully Sent Messages 본문

IT/Data Science

[Stratascratch/SQL] Successfully Sent Messages

Diana Kang 2025. 2. 26. 11:37 

# Soltuion 1
SELECT
	ROUND(
    	(SELECT COUNT(*) FROM facebook_messages_received) /
        (SELECT COUNT(*) FROM facebook_messages_sent),
        2
    ) AS success_ratio;
# Solution 2
SELECT
	(SELECT COUNT(*) FROM facebook.messages.received) /
    (SELECT COUNT(*) FROM facebook.messages.sent) AS received_to_sent_ratio;

'IT > Data Science' 카테고리의 다른 글

[Stratascratch/SQL] Find the total number of approved friendship requests in January and February  (0) 2025.02.26
[Stratascratch/SQL] Daily Interactions By Users Count  (0) 2025.02.26
[파이썬 정규표현식] re.sub()  (0) 2021.10.29
.iteritems() 함수  (0) 2021.10.29
[딥러닝을 이용한 자연어 처리 입문] 5. 벡터의 유사도(Vector Similarity) - 2. 여러가지 유사도 기법  (0) 2021.10.20
'IT/Data Science' Related Articles more