Guest User

Untitled

a guest
Oct 16th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. SELECT sum(IF(estado=0,1,2)) as "tramite", sum(IF(estado=1,2,0))
  2. as "Aceptado", sum(IF(estado=2,0,1)) as "Rechazado" FROM lugares
  3.  
  4. SELECT
  5. SUM(CASE WHEN estado = 0 THEN 1 ELSE 0 END) Tramite,
  6. SUM(CASE WHEN estado = 1 THEN 1 ELSE 0 END) Aceptado,
  7. SUM(CASE WHEN estado = 2 THEN 1 ELSE 0 END) Rechazado
  8. FROM lugares;
Add Comment
Please, Sign In to add comment