If the column is within your query, it must be in your group by statement. Ex: your first query only has "Ticket_Amount" in your group by where your second query has all of your columns in the group by statement because they are all in your Select statement which makes sense why the data looks "normal" for you.
You might be better off doing this as a sub query or rethinking what data you need instead of querying all the columns. You may need to rethink your schema as, with my limited understanding, it seems you've got multiple records per ticket in your paid table...i would think you'd have another table called say..."Ticket" with a foreign key to your Paid table and then you'd be able to this query more easily.
Otherwise off the top of my head you'll probably end up just having to do a subquery that would look something like.
SELECT *, (SELECT SUM([Amount_Paid]) FROM Paid AS B WHERE A.Transaction_DateTime LIKE '%2018%' GROUP BY Ticket_Number) FROM Paid AS A ORDER BY Transaction_Date_Time
Given i don't know your schema this is the other alternative subquery form that I think may work better...possibly
SELECT *, (SELECT SUM([Amount_Paid]) FROM Paid AS B WHERE A.Ticket_Bumber = B.Ticket_Number GROUP BY Ticket_Number) FROM Paid AS A ORDER BY Transaction_Date_Time
If you can't alter your schema, the above subquery is the only way i can think of accomplishing what you want to accomplish.
Submit an article or tip