Just a Web Code Solution
How to calculate the percentage from the values from two tables using sql ?
83
SQL
0
By 8 years ago
The power of the user (%)
0
TABLE NUMBERS1
ID POINTS
1 5
1 10
2 30
2 5
2 6
TABLE NUMBERS2
ID POINTS
2 5
1 10
2 30
2 5
1 6
MAX POINTS: 300
select ID, ROUND((SUM(POINTS) / 300) * 100) as number from (select ID, POINTS from NUMBERS1 UNION ALL select ID, POINTS from NUMBERS2) t group by ID order by number desc;
By 8 years ago
The power of the user (%)
The most helpful SQL solutions
how to execute select into using sql ?SQL
Click to see more ...
623
53
convert string to date sqlSQL
Click to see more ...
532
42
How to get the last record from table using sql ?SQL
Click to see more ...
458
33
create table sqlSQL
Click to see more ...
230
23
How use like using sql ?SQL
Click to see more ...
308
22
How to get the last 10 records using mysql ?SQL
Click to see more ...
202
21
rows to columns sqlSQL
Click to see more ...
158
17
insert new column into table sqlSQL
Click to see more ...
158
16
How to convert the values to lowercase using sql ?SQL
Click to see more ...
168
13
How to change a negative number to positive using sql ?SQL
Click to see more ...
119
11
- Related solutions:
- create table sql
230 23 - insert new column into table sql
158 16 - rename column sql
116 3 - convert string to date sql
532 42 - get date from datetime sql
86 1 -
Vote
0
- Latest solutions:
- create table sql
230 23 - insert new column into table sql
158 16 - rename column sql
116 3 - convert string to date sql
532 42 - get date from datetime sql
86 1 - get part of a string sql
80 0 - select year from datetime sql
116 1 - create table from select sql
139 3 - rows to columns sql
158 17 - delete table from databse sql
98 1 - Helpful solutions:
- how to execute select into using sql ?
623 53 - convert string to date sql
532 42 - How to get the last record from table using sql ?
458 33 - create table sql
230 23 - How use like using sql ?
308 22 - How to get the last 10 records using mysql ?
202 21 - rows to columns sql
158 17 - insert new column into table sql
158 16 - How to convert the values to lowercase using sql ?
168 13 - How to change a negative number to positive using sql ?
119 11
SQL
Would you like to receive an e-mail notification when new SQL solution is created?