¿Buscas ganar algo de dinero?

Adjudicado a:

Hi I'm very interested helping you optimizing your sql query like I did before when we work together, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do notMás

Hi,
This is Janos from Hungary - I'd like to help. Assuming you can run teamviewer I'm quite happy to connect up and do the modification in front of you while I talk you through it on skype. Also I'm happy to take aMás

Hi,
I can compact this query by using inner join instead of using embedded select. But I think that the real problem is the group by and order by. The columns that u group by, order by or put after the "where" must beMás

Hello there!
What you've asked for is not a problem to do at all, though I don't see why the sub-query is there in a firts place, could you explain more of where's this from and what's the use you make of it? Or it'Más

Hi,
First of all thanks for posting such a project.
I am oracle certified developer and dba with more than 5 years of experience.
I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer.
http://wwMás

Expert is [url removed, login to view] 5+yrs of [url removed, login to view] to start [url removed, login to view] do it [url removed, login to view] the admin and ftp details to start work [url removed, login to view] us to serve you [url removed, login to view] for your reply.....

Hi I have more than 10 years experience in Database administration and SQL query writing. If you want see some of sample work I can supply you. Please see my profile. Thanks. May be the following is your solution:
SMás

Hello,
I quickly tried with a revised query (without subqueries) with a few test records and got the same results. I'll send you the query if you are OK with my bid. You can accept my proposal formally only if the qMás

I already have solved your query to do not use sub query.
Your query is to count how many copies of each movie was downloaded by each user that had downloaded this movie before?
If that is correct, than I've doneMás