Answer the question
In order to leave comments, you need to log in
Can I withdraw money from AdSense to my IP if the application is posted on Google Play on behalf of an LLC?
Theoretical situation: there is an application on Google Play, earnings come from inaps and AdSense advertising. Accounts, of course, are registered to an LLC. The question is how legal it is to place ads in the application with an AdSense account owned by an individual. to a person or an individual entrepreneur, so that the money would immediately come to an individual / individual entrepreneur, and not an LLC?
Answer the question
In order to leave comments, you need to log in
SELECT *, SUM(`field with numbers`) AS summa FROM `table` GROUP BY `name`
will create a new field summa where the total value of each name will be written
So try
SELECT user.login, user.name, SUM(point_user.pointsCount), point.pointKey
FROM user, point_user, point
WHERE user.userId = point_user.userId AND point_user.pointId = point.pointId GROUP BY point.pointKey ORDER BY user.login
Based on:
1. The user + the type of points (for example, for the entrance) is the primary key (the number of points does not count because there is no need, suddenly in the future it will be necessary to change this number for each entry),
then the query should be something like this (I do not pretend to be accurate because I can't check
SELECT
u.login,
u.name,
SUMM(pu.pointsCount) as pointsCount,
p.pointKey
FROM
user u,
point_user pu,
point p
WHERE
u.userId = pu.userId AND
pu.pointId = p.pointId
ORDER BY u.login
GROUP BY
u.login,
p.pointKey
Thanks to all. helped. here is the final solution i needed
SELECT user.login, user.name, sum(point_user.pointsCount) pointsCount, point.pointKey
FROM user, point_user, point
WHERE user.userId = point_user.userId
AND point_user.pointId = point.pointId
GROUP BY user.login, user.name, point.pointKey
ORDER BY user.login
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question