Sort by

recency

|

5619 Discussions

|

  • + 0 comments

    select concat(name,'(',upper(left(occupation,1)),')') from occupations order by name asc;

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

  • + 0 comments
    SELECT O.name ||'('||substr(o.occupation,1,1)||')'
    from occupations as "O"
    order by name,occupation;
    
    select 
    'There are a total of '|| count(*) ||' '||lower(occupation)||'s.'
    from occupations
    group by occupation
    order by count(*), occupation ;
    
  • + 0 comments

    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;

  • + 0 comments

    Select name || '('|| substr(occupation,1,1) || ')' as result from occupations;

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

    /*

  • + 0 comments

    select Rpad(Rpad((Rpad(name,length(name)+1,'(')),length(name)+2,((substr(occupation,1,1)))),length(name)+3,')') from occupations order by name; select concat('There are a total of ',count(name)),concat(lower(occupation),'s.')from occupations group by occupation order by count(name);