FAANG Task#14 - Confirmation Rate | LEETCODE |SQL Challenge| Tuitions Tonight

Please support us on Patreon to grow / tonightstonight
JOIN our WhatsApp "Tuitions Tonight family": chat.whatsapp.com/L3lgd6u2BhV...
If you want help creating a project click here: / tuitionstonight
In this video, I will show you how to solve Task#14 - Confirmation Rate
Table: Signups
+----------------+----------+
| Column Name | Type |
+----------------+----------+
| user_id | int |
| time_stamp | datetime |
+----------------+----------+
user_id is the column of unique values for this table.
Each row contains information about the signup time for the user with ID user_id.
Table: Confirmations
+----------------+----------+
| Column Name | Type |
+----------------+----------+
| user_id | int |
| time_stamp | datetime |
| action | ENUM |
+----------------+----------+
The confirmation rate of a user is the number of 'confirmed' messages divided by the total number of requested confirmation messages. The confirmation rate of a user who did not request any confirmation messages is 0. Round the confirmation rate to two decimal places.
Write a solution to find the confirmation rate of each user.
Return the result table in any order.
Source Code: tuitionstonight.com/
Read Some Useful Articles here on our Website tuitionstonight.com
Complete Roadmap on How to Become Data Scientist in 3 Months?
tuitionstonight.com/roadmap-t...
Complete Roadmap on How to Become Data Analyst in 2 Months?
tuitionstonight.com/roadmap-t...
Complete Roadmap on How to Become Data Engineer in 3 Months?
tuitionstonight.com/roadmap-t...
Complete Roadmap on How to Become DevOps Engineer in 3 Months?
tuitionstonight.com/complete-...
------------------------------------------------------------------------------------------
🌓 FOR CONNECTION OF APACHE NETBEANS WITH MYSQL DBMS ⇙
➡️ • How to connect JDBC - ... ⇠ ⇠ ⇠
FOR MORE JAVA AND MYSQL PROJECTS
🔴Banking System using JAVA and MYSQL DBMS
➡️ • How to Create Banking ...
🔴School Management System using JAVA integrated with MYSQL Database
➡️ • Complete School Manage...
🔴Hospital Management System using JAVA integrated with MYSQL Database
➡️ • Complete Hospital Mana...
🔴CAKE SHOP MANAGEMENT System using JAVA and MYSQL DBMS
➡️ • Video
------------------------------------------------------------------------------------------
FOR SIMPLE JAVA SWINGS PROJECTS [WITHOUT DBMS]
🔴ACCOUNTING SYSTEM
➡️ • How to create Accounti...
🔴SCHOOL MANAGEMENT SYSTEM
➡️ • How to create School M...
🔴HOSPITAL MANAGEMENT SYSTEM
➡️ • How to make Hospital M...
🔴LIBRARY MANAGEMENT SYSTEM
➡️ • How to make Library Ma...
------------------------------------------------------------------------------------------
© Credit of Music goes to:
------------------------------------------------------------------------------------------
🔴For Promotions and Collaborations:
Email Us: [e-mail]
-------------------------------------------------------------------------------------------
🔥Visit our Website to see interesting articles🔥
tuitionstonight.com/
🔥𝙁𝙤𝙡𝙡𝙤𝙬 𝙪𝙨 𝙊𝙣 𝙎𝙤𝙘𝙞𝙖𝙡 𝙢𝙚𝙙𝙞𝙖 𝙛𝙤𝙧 𝙙𝙖𝙞𝙡𝙮 𝙛𝙚𝙚𝙙𝙨🔥
Instagram: / tuitionstonight
Instagram: / muhammad_taha_azam
Facebook: TT7.in/?moda...
------------------------------------------------------------------------------------------
Like, Subscribe & share
Support our Channel
Tuitions Tonight
tuitionstonight.com/
[e-mail]

[@sharvilwadekar2526]

Why did you stopped posting these videos? please complete all 50 questions