Subjects
PRICING
COURSES
SIGN IN
Start Free Trial
Prem K.
Software Engineer @ Cerner Corporation
Tutor Satisfaction Guarantee
Databases
TutorMe
Question:

A statement like: SELECT orgName, COUNT(*) AS dupes FROM organizations GROUP BY orgName HAVING (COUNT(*) > 1) Will return something like orgName | dupes ABC Corp | 7 Foo Federation | 5 Widget Company | 2 Is there any way to do this? Maybe like a orgName | dupeCount | id ABC Corp | 1 | 34 ABC Corp | 2 | 5 ... Widget Company | 1 | 10 Widget Company | 2 | 2

Prem K.
Answer:

select o.orgName, oc.dupeCount, o.id from organizations o inner join ( SELECT orgName, COUNT(*) AS dupeCount FROM organizations GROUP BY orgName HAVING COUNT(*) > 1 ) oc on o.orgName = oc.orgName

Calculus
TutorMe
Question:

Use Integration by Parts. (integral)ln(x) dx

Prem K.
Answer:

set u = ln(x), dv = dx then we find du = (1/x) dx, v = x substitute (integral) ln(x) dx = (integral) u dv and use integration by parts = uv - (integral) v du substitute u=ln(x), v=x, and du=(1/x)dx = ln(x) x - (integral) x (1/x) dx = ln(x) x - (integral) dx = ln(x) x - x + C = x ln(x) - x + C.

C Sharp Programming
TutorMe
Question:

Reverse a string using a built-in function.

Prem K.
Answer:

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace Programs { public class Programs { public static void Main(string[] args) { Console.WriteLine("Please Enter string:"); string strInput = Console.ReadLine(); char[] charArray = strInput.ToCharArray(); Array.Reverse(charArray); Console.WriteLine(new string(charArray)); Console.ReadLine(); } } }

Send a message explaining your
needs and Prem will reply soon.
Contact Prem
Ready now? Request a lesson.
Start Session
FAQs
What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Session" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.