-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathgraficadonita
135 lines (92 loc) · 4.07 KB
/
graficadonita
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
drop table tmp
CREATE TEMP TABLE tmp AS (
SELECT DISTINCT ON (a.nombre) b.username as user__username ,count(a.id) as total
FROM
public.principal_alumno a
join public.users_user b ON a.user_id = b.id
join public.principal_cicloescolar c ON c.id = a.ciclo_id
WHERE a.escolaridad not in ('No Estudia y tiene edad escolar','No Tiene Edad escolar') and c.status=true
group by b.username,a.id);
Select a.user__username,count(a.total) as total from tmp2 a group by user__username order by total desc
****************************
nuevo metodo
drop table tmp
CREATE TEMPORARY TABLE tmp (maestra char(80), total int);
select * from tmp
SELECT DISTINCT ON (a.nombre) b.username as user__username ,count(a.id) as total
INTO tmp2
FROM principal_alumno a
join users_user b ON a.user_id = b.id
join principal_cicloescolar c ON c.id = a.ciclo_id
WHERE c.status=true and a.escolaridad not in ('No Estudia y tiene edad escolar','No Tiene Edad escolar')
group by b.username,a.id
select * from tmp2
INSERT into tmp (maestra,total) values (SELECT DISTINCT ON (a.nombre) b.username as user__username ,count(a.id) as total
FROM principal_alumno a
join users_user b ON a.user_id = b.id
join principal_cicloescolar c ON c.id = a.ciclo_id
WHERE c.status=true and a.escolaridad not in ('No Estudia y tiene edad escolar','No Tiene Edad escolar')
group by b.username,a.id )
Select b.username, count(a.id)
FROM
public.principal_alumno a
join public.users_user b ON a.user_id = b.id
join public.principal_cicloescolar c ON c.id = a.ciclo_id
WHERE a.escolaridad not in ('No Estudia y tiene edad escolar','No Tiene Edad escolar') and c.status=true
group by b.username
SELECT DISTINCT ON (a.nombre)
b.username,a.id,a.nombre
FROM
public.principal_alumno a
join public.users_user b ON a.user_id = b.id
join public.principal_cicloescolar c ON c.id = a.ciclo_id
WHERE a.escolaridad not in ('No Estudia y tiene edad escolar','No Tiene Edad escolar') and c.status=true
group by b.username,a.id
drop table tmp
CREATE TEMP TABLE tmp AS (
SELECT DISTINCT ON (a.nombre)
b.username,count(a.nombre) as alumnos
FROM
public.principal_alumno a
join public.users_user b ON a.user_id = b.id
join public.principal_cicloescolar c ON c.id = a.ciclo_id
WHERE a.escolaridad not in ('No Estudia y tiene edad escolar','No Tiene Edad escolar') and c.status=true
group by a.nombre,b.username
);
Select a.username as Maestra,count(a.alumnos) as AlumnosAtendidos
from tmp a
group by username
Select a.username as Maestra,a.alumnos as AlumnosAtendidos
from tmp a
group by username
SELECT DISTINCT ON (a.nombre) b.username as user__username ,count(a.id),a.nombre --as total INTO tmp
FROM principal_alumno a
join users_user b ON a.user_id = b.id
join principal_cicloescolar c ON c.id = a.ciclo_id
WHERE c.status=true and a.escolaridad not in ('No Estudia y tiene edad escolar','No Tiene Edad escolar')
group by b.username,a.id
SELECT DISTINCT ON (a.nombre) b.username,a.id ,a.nombre
FROM principal_alumno a
join users_user b ON a.user_id = b.id
join principal_cicloescolar c ON c.id = a.ciclo_id
WHERE atencion in('Psicologia') and
c.status=true and a.escolaridad not in ('No Estudia y tiene edad escolar','No Tiene Edad escolar')
order by a.nombre,a.id
select * FROM principal_alumno WHERE atencion='Psicologia'
--esta es laba se de anoche
drop table tmp
SELECT DISTINCT ON (a.nombre) b.username,a.id ,a.nombre --into tmp
FROM principal_alumno a
join users_user b ON a.user_id = b.id
join principal_cicloescolar c ON c.id = a.ciclo_id
WHERE c.status=true and a.escolaridad not in ('No Estudia y tiene edad escolar','No Tiene Edad escolar')
order by a.nombre,a.id
select username,count(id) from meme group by username
---***los que tiene realmente
SELECT a.nombre,b.username
FROM principal_alumno a
join users_user b ON a.user_id = b.id
join principal_cicloescolar c ON c.id = a.ciclo_id
WHERE c.status=true and a.escolaridad not in ('No Estudia y tiene edad escolar','No Tiene Edad escolar')
group by nombre,b.username
order by b.username