p.ViewCount AS 'Nombre de vues' 6 FROM Posts p
Q&A for scientists using computers to solve scientific problems
SELECT p.OwnerDisplayName AS 'auteur', p.Title AS 'titre', pt.Name AS 'Type de post', p.ViewCount AS 'Nombre de vues' FROM Posts p JOIN PostTypes pt ON p.PostTypeId = pt.Id WHERE p.ViewCount = ( SELECT MAX(p.ViewCount) FROM Posts p);