/* Advanced SQL
Set operators: DIVISION problem
*/


/* Count how many workshop students have attended. */


select stdid, stdfname, stdlname, COUNT(*) "Workshop Count"
from students, attendances
where stdid =attnd_stdid
group by stdid, stdfname, stdlname
order by count(*) desc;