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
|
5566 Discussions
|
Please Login in order to post a comment
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;
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;
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;
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)
THE FULLSTOP!!!