Solve Query for DBA
₹100-400 INR / tunti
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
Projektin tunnus: #24636293
Tietoa projektista
Myönnetty käyttäjälle:
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ää
16 freelanceria on tarjonnut keskimäärin ₹251/tunti tähän työhön
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ää
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
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
I can successfully manage your project Relevant Skills and Experience I am an expert in database development. My experience in mysql is superior.
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ää
After reviewing the requirements, i will implement a Sql query to solve the problem, using a subselect in order to get the mutual friends.
Hello, I am a certified sql server dba developer, i can help you with the requested querry. Have a nice dat.
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