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
|
5619 Discussions
|
Please Login in order to post a comment
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;
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;
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;
/*
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);