Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT sum(IF(estado=0,1,2)) as "tramite", sum(IF(estado=1,2,0))
- as "Aceptado", sum(IF(estado=2,0,1)) as "Rechazado" FROM lugares
- SELECT
- SUM(CASE WHEN estado = 0 THEN 1 ELSE 0 END) Tramite,
- SUM(CASE WHEN estado = 1 THEN 1 ELSE 0 END) Aceptado,
- SUM(CASE WHEN estado = 2 THEN 1 ELSE 0 END) Rechazado
- FROM lugares;
Add Comment
Please, Sign In to add comment