Q&A for Tridion developers and administrators
/*SQL Practice*/ /*The(quiet{mouse retreats to})the[hole]*/ /*Part 2*/ /*Select DisplayName, Id, Location, Reputation From Users;*/ /* Right Answer to sort by descending order Select DisplayName, Id, Location, Reputation From Users ORDER BY Reputation DESC; */ /* Right Answer to display ALL rows of User table with Reputation greater than 550K Select * From Users Where Reputation >= 550000; */ /* SELECT Id, Name, Class, Date FROM Badges */ SELECT Id, Name, Class, Date FROM Badges WHERE Date like '2016-%';