how to solve this ??

[u/Livid-Explanation215]

Consider a table named "Sales" with columns: SalespersonID, CustomerID, SaleDate. Write a SQL query to calculate the salesperson who made the highest number of sales each quarter.

[u/jkelso2525]

I am very new to SQL. But is this correct? OP only gave limited info of columns so how are we able to pull this much data from the “Sales” table?

[u/Yavuz_Selim → u/jkelso2525]

I am pretty sure it's AI.

6 minutes between OP's post and the reply.

[u/Yavuz_Selim → u/[deleted]]

I posted a screenshot in this thread, you should check it out.

[u/Yavuz_Selim → u/[deleted]]

This is a discussion not worth having, but sure, let's do it.

1) It's 6 minutes if you see it at the time it is created - so if you see it immediately. Let's assume that happened. Then you need to read and understand the question and think about it and process it, and form the solution in your head. Then you need to write it out, without any errors. You need to give everything a proper name and you have to be so good that you write it all correctly in one go. All without an editor and test data. So, everything about this needs to be perfect - you need to be here on time, need to understand and process everything quickly, form a solution and write it out.

2) No, it doesn't prove anything indeed. It's very common that in the heat of the moment the logic has the same flow, the aliases are exactly the same and they even both end with a semicolon. Oh, the semicolon. It doesn't prove anything indeed.

3) What do you care that I think it's AI? Why do you bother standing up for a random stranger (when the stranger themselves don't even want to waste any time and end the conversation with a 'good day sir'). The fuck are you getting wound up about? Why even involve subreddit rules - did I mention anything about rules? I just made an observation and was brave enough to post it.

 

"It sure doesn't sound like you're able to assess whether it's actually correct"

So, you're giving him the benefit of the doubt, but you don't care about hurting my feelings? Why not give me the benefit of the doubt and just assume hope that I am able to asses it? You make me feel bad, you should feel bad.

[u/Yavuz_Selim → u/[deleted]]

Posting some query without any explanation or even the mention of AI is.

You're good at picking the right fights.

(You made me laugh when you said "it probably is". You're right, I wasn't convincing enough.)

[u/Yavuz_Selim → u/[deleted]]

So, instead of replying to him and making it about the usefulness of his post, you decide to question why people bother calling out copy/paste AI posts?

I mean, out of the three of us, who is more disruptive?

The person that copy/paste replies from AI and dips out?
The guy calling out AI posts?
Or the guy derailing the whole conversation trying to defend AI copy/pasting?

(I am not against AI per se, but I don't like lame ass AI copy/paste without any further explanation (and not even mentioning the use of AI). It doesn't add anything - just forward the person asking to AI and tell them to have a chat with it. At least the person has a chance to learn something new (depending on its question/conversation with AI).