Sort by

recency

|

5566 Discussions

|

  • + 0 comments

    select name_fin from (select concat(name,'(',left(occupation,1),')') as name_fin from occupations order by name) as table1 union select concat('There are a total of ',count(occupation),' ',lower(occupation),'s.') as name_fin from occupations group by occupation order by name_fin;

  • + 0 comments

    select name||'('||substr(occupation,0,1)||')' from OCCUPATIONS order by name asc ;

    select 'There are a total of '||count()||' '||lower(occupation)||'s.' from occupations group by occupation order by count() asc, occupation asc;

  • + 0 comments

    SELECT CONCAT(name,'(',left(occupation,1),')') as _name 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;

  • + 0 comments

    Select CONCAT(Name, '(',LEFT(Occupation,1),')') from OCCUPATIONS order by CONCAT(Name,'(',LEFT(Occupation,1),')');

    SELECT CONCAT('There are a total of',' ',COUNT(Occupation),' ', LOWER(Occupation),'s.') FROM OCCUPATIONS group by Occupation order by COUNT(Occupation)

  • + 0 comments

    THE FULLSTOP!!!