Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone check my query based off my pics thank you! begin{tabular}{|c|c|c|c|c|} hline multicolumn{7}{|c|}{ friend_requests } hline action_id & requester_id & requestee_id & action_timestamp

can someone check my query based off my pics thank you! image text in transcribed
image text in transcribed
\begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ friend_requests } \\ \hline action_id & requester_id & requestee_id & action_timestamp & action_taken \\ \hline 1 & 1037392 & 3437315 & 2015031500:01:05 & Requested \\ \hline 2 & 2138102 & 5438443 & 2015031500:01:07 & Accepted \\ \hline 3 & 2331234 & 1231232 & 2015031500:01:08 & Rejected \\ \hline \end{tabular} Question 3B: Write a second query to determine the percentage of requests that are Accepted. (SELECT COUNT(*) *100 / (SELECT COUNT(*) FROM friend_requests) FROM friend_requests WHERE action_taken = 'Accepted')

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions