Solve Query for DBA

Suoritettu Julkaistu 4 vuotta sitten Maksettu toimituksen yhteydessä
Suoritettu

Hello DBA,

please find attachment for addfriend table

you have two table one is user and another is addFriend

>user have struture

userID Username dob address created_at updated_at

>addfriend have strutre

friend_id blocked req_status friend_user_id user_id blocked_by created_at updated_at

i want result by query is:

i want list of top 10 user whos have maximum mutual friend with me(login User) but they are not my friend

Oracle SQL Tietokannan hallinto MySQL Tietokantaohjelmointi

Projektin tunnus: #24636293

Tietoa projektista

16 ehdotusta Etäprojekti Aktiivinen 4 vuotta sitten

Myönnetty käyttäjälle:

ravipatel2209

Hello Sir, I have good control over SQL server Database. I can do your task quickly and accurately. I am B.E. Computer Engineer. I have 6 Year of Experience in IT field. I am Team Leader in my Company. I have worked on Lisää

₹100 INR / tunti
(1 arvostelu)
0.0

16 freelanceria on tarjonnut keskimäärin ₹251/tunti tähän työhön

khyatitankariya

Hello, I got your point, and if you are aware with mysql query, than this is very simple task if you know the structure. First you have to fetch your friend's user ID (ufid) and then you have to fetch your friend Lisää

₹400 INR / tunti
(12 arvostelua)
5.4
aap31374

I  have more then 15 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design, modeling and performance tun Lisää

₹556 INR / tunti
(6 arvostelua)
3.3
Abhishek123kumar

Hey, I am interested to work on your project and i believe that i am very good at writing SQL. I Can complete your within given time. Thanks

₹100 INR / tunti
(0 arvostelua)
0.0
AnggaSetyawan91

I have 9 years experience in telco business. I have knowledge vas rbt,sql,mysql,excel,word,linux Relevant Skills and Experience My sql,sql,excel,unix

₹278 INR / tunti
(0 arvostelua)
0.0
lukmonak

I can successfully manage your project Relevant Skills and Experience I am an expert in database development. My experience in mysql is superior.

₹278 INR / tunti
(0 arvostelua)
0.0
ishanthaaa9

Thanks for the opportunity to provide a proposal for your database needs! As a freelance, I’ve found that many clients enjoy my unique problem solving style, high quality of work, and reasonable rates. In this proposal Lisää

₹250 INR / tunti
(0 arvostelua)
0.0
jgarc

After reviewing the requirements, i will implement a Sql query to solve the problem, using a subselect in order to get the mutual friends.

₹278 INR / tunti
(0 arvostelua)
0.0
catalinlupascu04

Hello, I am a certified sql server dba developer, i can help you with the requested querry. Have a nice dat.

₹100 INR / tunti
(0 arvostelua)
0.0
nitinkarikot91

Hi I am working as a Data Analyst for more than 5+ years and I have strong knowledge in SQLs. I guess the query you are suggesting is a maximum of 2mins work. Thanks

₹100 INR / tunti
(0 arvostelua)
0.0