Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT v.idvideo IdVideo,
- (SELECT COUNT(*) FROM historique h , utilisateur u WHERE v.idvideo = h.idvideo AND h.login = u.login AND u.nat='France') Vu_Francaise ,
- (SELECT COUNT(*) FROM historique h , utilisateur u WHERE v.idvideo = h.idvideo AND h.login = u.login AND u.nat='Allemagne') Vu_Allemande,
- ((SELECT COUNT(*) FROM historique h , utilisateur u WHERE v.idvideo = h.idvideo AND h.login = u.login AND u.nat='France')-(SELECT COUNT(*) FROM historique h , utilisateur u WHERE v.idvideo = h.idvideo AND h.login = u.login AND u.nat='Allemagne')) Diffrence_Vu
- FROM video v
- ORDER BY (ABS(Diffrence_Vu)) DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement