We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Advanced Select
- The PADS
- Discussions
The PADS
The PADS
Sort by
recency
|
4847 Discussions
|
Please Login in order to post a comment
MS SQL SERVER: SELECT CONCAT(NAME , '(' , SUBSTRING(OCCUPATION,1,1) , ')') FROM OCCUPATIONS ORDER BY NAME; SELECT CONCAT('There are a total of ' , COUNT(OCCUPATION) , ' ' , lower(OCCUPATION) + 's.') FROM OCCUPATIONS GROUP BY OCCUPATION ORDER BY COUNT(OCCUPATION), OCCUPATION;
SELECT CONCAT ( Name, '(', LEFT(Occupation,1), ')' ) AS ONAME FROM occupations ORDER BY Name ASC;
SELECT CONCAT("There are a total of ",COUNT(Occupation),' ',LOWER(Occupation),'s.') AS ODETAILS FROM occupations GROUP BY Occupation ORDER BY COUNT(Occupation), Occupation ASC;
Select CONCAT(Name, '(', Left(Occupation, 1), ')') from Occupations Order by Name; Select CONCAT('There are a total of ', Count(Occupation), ' ', lower(Occupation), 's.') from Occupations group by Occupation order by count(Occupation), occupation;
What's wrong?
SELECT CONCAT(name,'(',LEFT(occupation,1),')') FROM occupations ORDER BY name;
SELECT CONCAT ('There are a total of', COUNT(occupation),' ',LOWER(occupation),'s') FROM occupations GROUP BY occupation ORDER BY COUNT(occupation) ASC, occupation ASC;